Browse by Tags

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 hours. I'm using it in a dashboard to show me how well my health check solutions are working on...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 10-25-2007
Filed under: SMS 2003, SMS Reports
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 was run. The details are as follows: Automation error Error Number: -2147217392 Source: SMSComponent...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 10-03-2007
Filed under: SMS 2003, SMS Reports, SMS 2003 SP3
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 info from. SELECT DISTINCT Sys.Netbios_Name0 , Sys.Client0 , Sys.Operating_System_Name_and0 , v_RA_System_IPAddresses...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 09-12-2007
Filed under: SMS 2003, SMS Reports
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 need to create the table and stored procedure I used in my previous ITMU reports to get the v_ms_patch_list...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 09-10-2007
Filed under: SMS 2003, SMS Reports, SMS 2003 SP3
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: Agency Patched Total Requests Total Clients Percent_Compliant Date_ran Agency = Department Patched...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 02-23-2007
Filed under: SMS 2003, SMS Reports
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 responsible for reporting on 42 agencies. Some of the agencies are under our main Domain and some of...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 02-12-2007
Filed under: SMS 2003, SMS Reports
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 MS today because I needed to get my numbers correct because I had to make a new report that shows...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 02-12-2007
Filed under: SMS 2003, SMS Reports
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 just say i like to automate things whenever possible. (Lazy ) With help from others on the mailing...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 01-19-2007
Filed under: SMS 2003, SMS Reports
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 (uses same logic used for creating a collection for not in) to list the Sites that do not have ITMU...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 01-19-2007
Filed under: SMS 2003, SMS Reports
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.Name0 FROM v_GS_SYSTEM INNER JOIN v_FullCollectionMembership ON v_GS_SYSTEM.ResourceID = v_FullCollectionMembership...

Posted to Chris Stauffer at myITForum.com (Weblog) by cstauffer on 02-15-2008
Filed under: SMS 2003, SMS Reports, SMS 2003 SP3

Page 1 of 2 (14 items) 1 2 Next >