Author: Simon B

Sccm reports and users management

Here’s some reports I’ve create to help our technical support team with the management of users in Active directory, So the first report will give you a count of users by  status, Enable, Disable, Password Set to never Expired, Account Expired and Stale Account ( which as exceed their threshold of 90 days). Also, with the ability to get a list of all user accounts with a specific statu...

Get email notification when advertisement failure exceed a threshold

Recently, a client asked me to provide a way to receive email notifications when advertisement failures have exceeded a certain threshold. So here’s the basic step I’ve followed to meet that need; Create a report, which containt all the failures informations, create a weekly SQL agent job, which will send a email if the failure count exceed the threshold. Note that, if you want to be a...

Sccm – Add a description to the error code in sccm reports

In some of the reports in sccm the result will display a error code for troubleshooting purpose, but often they dont provide any description about this error code. So here’s a example on how you can get more detail on these errors. Note that in this example I will use a report on Software update – client health report. 1- You must download the following file, convert it to csv, replace all the com...

Sccm – Last Logon Timestamp, Last Password Set, and other BigInt vs reporting

Often I had to convert BigInt attributes discovered by Sccm for reporting. Whether to create reports about the LastPasswordSet, lastogontimestamp, etc . So here’s an example of the query I use in these situations; SQLQuery (SELECT User_Name0 as ‘UserName’, DATEADD(mi,(lastLogontimeStamp0 / 600000000) – 157258080,0) AS ‘LLTS’, DATEADD(mi,(PwdLastSet0 / 600000000)...

Sccm – Security updates compliance status by collection

Here’s some reports that I use to monitor the level of compliance for security updates by collection. Also it’s possibe to drill down and see which security updates is missing. Report Queries, Original Post: http://anotherblabla.wordpress.com/2012/03/22/sccm-security-updates-compliance-overview-report-v2/ thanks to Garth Jones and Anoop for sharing these informations, which has been very helpfull ...

Remove previous versions of a application during a software deployment

During some deployment, the installation cannot update or uninstall previous versions. So here’s a autoit script I created to allows to scan the registry to detect and uninstall previous versions. So, to be successfull you must modify the values of $Software = “Adobe reader” $apps1 = “C:\Adobe\fr\AcroRead.msi” $Mst = “C:\Adobe\fr\AcroRead.mst” If $DisplayV...

Software updates and user notification

Here’s a AutoIt scipt to notify users when their computers are in pending reboot, following a Software update deployment with SCCM. Basicly, script will scan the registry and check if the computers are in pending reboot (due to deployment of the update via SCCM). If so, it Will use the windows updates icon(detect which icon to use  for  WinXP, 2003, Win 7 and 2008) in the systray and allow u...

SCCM – HTA Script to postpone software deployment

here’s a HTA application that I’ve developed to allow users to postpone a deployment. This allow you to notify the users in a language other than the sccm client (if you dont have the ICP installed), set the number of times it may postpone the installation, set a timer on the installation if any responds, kill processes if necessary (possible to enforce if needed) and also simplify the...