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...
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.BulletinID [Superseded BulletinID], info2.ArticleID...
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 InterfaceType0 = ‘USB’ and Resource_Domain_or_Workgr0 IN (‘@Domain’) order by Resource_Domain_or_Workgr0,sys.Operating_System_Name_and0,sys.Name0
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...
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...
roncrumbaker: Great link! Lots of information out there...and yes, there are many v...
Geoff Buckingham: Been trying to get some work done on mine for a long time ... without ...
Clint Huffman: Page file sizing depends on the crash dump setting of the system as we...
TGH: We try our best over at www.techygeekshome.co.uk ! mostly out of our o...
James: I think the Survival guide would be a good link: http://social.technet...