Author: Casey Robertson

SCCM–How to Report on Safeboot / McAfee Endpoint Encryption

I posted this on the myITForum SMS mailing list and thought it might be helpful. A question was asked about reporting on systems using Safeboot and verifying their encryption state – this was my answer: Here you go Suzzi (we use the same product). I’d recommend using your own naming conventions for the class but the meat of it is there. And yes, Inventory Manager helps a lot with this kind of stuf...

SCCM SQL Query–Patch Supersedence Report

I wanted a way to input a patch KB article and find out if the patch superseded another patch or was superseded by another. For parameters I used the ArticleID field aka the KBNumber. select cir.FromCIID [New CI], info.BulletinID [New BulletinID], info.ArticleID [New ArticleID], info.Title [New Title], info.InfoURL [New InfoURL], info.DatePosted [New DatePosted], cir.ToCIID [SUPERSEDED CI], info2....

SQL Query to Enumerate USB drives by Domain

–Enumerate USB Drives– select sys.Name0 [System Name], sys.Resource_Domain_or_Workgr0 [Domain], sys.Operating_System_Name_and0 [O/S], disk.Description0 [Description], disk.InterfaceType0 [Bus Type], disk.Model0 [Model], disk.Name0 [USB Drive Name], disk.Size0 [Size], disk.DeviceID0 [DeviceID] from v_R_System sys join v_GS_DISK disk on sys.ResourceID = disk.ResourceID where InterfaceTyp...

Using SQL pivots for SCCM data queries

This is probably elementary for the SQL gurus out there but I learned something new yesterday and thought I would share it. Have you ever had multiple row entries that you wanted to roll up into a columnar format? This situation arose the other day when a poster on the myITforum mailing list was trying to take multiple rows from the view v_AgentDiscoveries to report on SCCM client discovery metric...

What to do if your server won’t print

Ran into an issue last night that I had never seen before. One of our Citrix servers simply stopped printing. If you have worked with Citrix for any length of time you know that printing is one of the big pain points but in this case it actually was not a Citrix problem. This server would not print to local or networked printers, via Citrix or otherwise. Multiple reboots did not help. Nor did rein...