Recently the agency I work for had a SCCM health check run on our main consolidated site.
Note: I Highly recommend having one of these done even if you think everything is running perfect. As I learned even though it was running great there are always things that can be tweaked to make things run even better.
Anyway the one thing that I was shocked to be gigged on was that several of my Protected DP’s were missing BITS and WEBDAV. Now this really peeved me because I built all those sites myself and I knew for a fact that it was setup correctly. Which means that someone went behind me and removed BITS and WEBDAV and in some cases disabled them. My best guess is that some server admin thought he was following “best security practices” and turned them off to make the server more secure, not realizing that they just broke part of SCCM.
So after calming down about getting gigged on something that I never should have I setout on a quest to create a DP health DCM to ensure that this doesn’t happen again.
I’ve imported the updated SCCM DCM checks (already had the original checks imported) and i created 4 checks that will check for BITS and WEBDAV.
Then setup a baseline that contains the following:
The baseline and configuration items are attached. All you have to do is import the cab.
Note: The BITS and WEBDAV scripts check to see if they are installed. I also have a second script to ensure that they are enabled.
Please let me know if you find any issues. I’ve fully tested this in production on the following setup:
Server 2003 SP2
SCCM 2007 SP1 R2
It has NOT been tested on Server 2008.
Note: If you ever need to setup a DCM using a script simply follow Steve Thompson’s directions for creating a DCM with a script to get them setup.
http://myitforum.com/cs2/blogs/sthompson/archive/2009/03/30/detect-computer-reboot-pending-with-dcm.aspx
If anybody else has anything else that they think needs to be checked on PDP’s please feel free to share.
Jimmy Martin put together some awesome reports that can be used in an SCCM dashboard. This dashboard allows you to see what a site has been doing for the last 4 months.
SCCM Site Monthly Totals
This series of reports can be used to create a report dashboard to show the last three months of creation, edit, and deletion activity for collections, packages, programs, and advertisements
Advertisement Success Rate Site Wide
These two reports will show a count of the advertisement results for the entire site. One is for month to date and the other is last month's data.
In addition to this i created a drill though for the Advertisement Success rate reports. This will allow you to see exactly what Advertisement is causing the problem and will allow you to clean up your status.
Simply create a new report with the code below then link it to the reports above.
you can link it to each of the advertisement report. you will need to create a new one for each report you link.
Make sure that you change this code
GETDATE()) = 0) to match the GETDATE()) = 0) from the first report
So if it is 0 then make it 0 if it is 1 then make it 1 ETC…
Here is the code:
SELECT v_R_System.Name0 AS 'Machine Name'
, CASE WHEN v_R_System.Client0 = '1' THEN 'yes' WHEN v_R_System.Client0 = '0' THEN 'no' ELSE 'no' END AS 'Client'
, CASE WHEN v_R_System.Obsolete0 = '1' THEN 'yes' WHEN v_R_System.Obsolete0 = '0' THEN 'no' ELSE 'no' END AS 'Obsolete'
, v_ClientAdvertisementStatus.LastStateName AS Status
, v_AdvertisementInfo.AdvertisementName As 'AD Name'
, v_ClientAdvertisementStatus.AdvertisementID AS 'Ad ID'
FROM v_ClientAdvertisementStatus INNER JOIN
v_R_System ON v_ClientAdvertisementStatus.ResourceID = v_R_System.ResourceID INNER JOIN
v_AdvertisementInfo ON v_ClientAdvertisementStatus.AdvertisementID = v_AdvertisementInfo.AdvertisementID
WHERE (DATEDIFF(m, v_ClientAdvertisementStatus.LastStatusTime, GETDATE()) = 0)
AND (v_ClientAdvertisementStatus.LastStateName = @Status )
ORDER BY 'Ad ID', 'Machine Name'
Awesome reports Jimmy :-)
Chris Stauffer <><