Category Archives: SMS Query

All Known sccm queries, to make administrator life easy

Track movies, mp3 and photos from SCCM 2007

Agenda Track movies, mp3 and photos from SCCM 2007 solution :- To acheive this, we need to enable inventory all requested format in SCCM 2007.   After enabling the above settings, use the below query to get the details. select … Continue reading

Posted in SMS Query | Tagged , , | Leave a comment

SCCM collection for systems with IE 9

Use the below Query to create collections for the systems with Internet explorer 9 Note :- This query will work only, when you have enabled inventory collection for *.exe files. select distinct SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS_R_System.SMSAssignedSites, SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner … Continue reading

Posted in SMS Query | Tagged , | Leave a comment

SQL Query to check when collection were updated

Hi Use the below Query to check, when the collections were updated in SCCM 2007 Select  CC.CollectionID, CN.CollectionName, Convert (VarChar(10), CC.TimeUpdated, 101)‘Last Updated’ From Collection_MemberChg_Notif CC Join Collections CN on CC.CollectionID = CN.SiteID Order By [Last Updated] DESC

Posted in SMS Query | 2 Comments