Chris Stauffer at myITForum.com

You want me to do What?

Browse by Tags

All Tags » SMS Reports (RSS)
Memory Report by Collection
Here at the state I get some interesting requests sometimes. The latest task was to create a report that would show a count of machine at 500 meg intervals. I had some ideas of how to do it and I knew...

Posted by cstauffer | 2 comment(s)

Server Tracking tool
This tool will allow you to track information about servers that are built. it was created with SMS installer and it takes a little work to get it put together. It can also be altered to ask for additional...

Posted by cstauffer | with no comments

IE Logon script
On the SMS List we were talking about the changes that occured in SCCM for remote control and I suggested that people use a logon script that actually creates a log so that you didnt need to see it run...

Posted by cstauffer | with no comments

Report for SMS 2003 and SCCM 2007 Security by John Nelson
SMS Permissions matrix http://myitforum.com/cs2/blogs/jnelson/archive/2008/05/30/117881.aspx SCCM Permissions Matrix http://myitforum.com/cs2/blogs/jnelson/archive/2008/05/30/117883.aspx John Nelson

Posted by cstauffer | with no comments

How to add a collection prompt to a report
Several people have asked repetedly how to make a report focus on a collection. Well the secret is the v_FullCollectionMembership view. Here is how to add it. The best way to do it is this: SELECT v_GS_SYSTEM...

Posted by cstauffer | with no comments

24 hour Advertisement report
I had to create a report today that only shows the newest numbers for an advertisement. I wanted to use it for the Health Checks. This report will show me the results of an advertisement for the last 24...

Posted by cstauffer | with no comments

Filed under: ,

SMS Webreports Error -2147217392 (Solution)
Report Name: All advertisements Category: Software Distribution - Advertisements Comment: Displays all of the advertisements at this site. Parameters: All advertisements An error occurred when the report...

Posted by cstauffer | 1 comment(s)

SMS 2003 Health Check Report: Machines missing a Site assignment
This report will show you all of the machines that are not assigned to a Site. This will allow you to figure out what boundaries are missing. Just change the collection ID to the collection you need the...

Posted by cstauffer | with no comments

Filed under: ,

ITMU patches released or re-released in the last 30 days
Here is a report that will show you any patches released or re-released in the last 30 days. I dont like that it is showing old patches but it is a starting point. Maybe someone can add to it :-) You will...

Posted by cstauffer | with no comments

Enterprise Patch Management Report
Explanation Of Request I was asked to produce a Patch Status Summary report that would display the status of each Department that is presently tracked though SMS. This report was to contain the following...

Posted by cstauffer | 1 comment(s)

Filed under: ,

Server Client Report
I need a report that would show all of the server that are located in SMS and it needed to tell me how many server had the client and how many where missing. This sounds easy but in my environment I am...

Posted by cstauffer | 1 comment(s)

Filed under: ,

NEW ITMU Reports
I’ve had a problem with the ITMU reporting for some time. The problem was associated with MS06-014. This patch was showing 10-15 times the numbers it should have been showing. I almost open a ticket with...

Posted by cstauffer | 1 comment(s)

Filed under: ,

ITMU Critical patch List
Management asked me a few weeks ago for a report that would show only the critical patches. I found a report posted on the forum that would work but it required that i update it every month and well lets...

Posted by cstauffer | with no comments

Filed under: ,

ITMU Version Report
I have a large Central site that controls 35 agencies. I needed a report that would list the status of every agencies ITMU upgrade process. I removed the part for no file version and made a not in query...

Posted by cstauffer | with no comments

Filed under: ,