System Center

Report to show major Internet Explorer version

For more details see. http://social.technet.microsoft.com/Forums/systemcenter/en-US/14bb9caa-5f0b-418e-88b5-e359ef6d116b/report-to-show-major-internet-explorer-version?forum=configmgrreporting select SF.FileName, OS.Caption0, replace(left(SF.FileVersion,2), '.','') as 'IE Version', Count (Distinct SF.ResourceID) as 'Total' From dbo.v_GS_SoftwareFile SF JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID JOIN dbo.v_GS_OPERATING_SYSTEM OS ON SF.ResourceID = OS.ResourceID join dbo.v_GS_SYSTEM S on SF.ResourceID = S.ResourceID Where SF.FileName = 'iexplore.exe' and SF.FilePath like '%Internet Explorer%' and S.SystemRole0 = 'Workstation' Group by SF.FileName, OS.Caption0, replace(left(SF.FileVersion,2), '.','') Order by ...

ConfigMgr – Application Base variables the easy way with Powershell

This article I planned on writing for some time now (as a lot of others) but didn’t find the time yet. The topic itself isn’t new, it’s the solution that’s cool (although itself also not too new). Install Applications according to dynamic variable list There is more than one way of how you can install applications (and packages) during a Task Sequence and each of them has its pros and cons. There is the “Install Application” step which lets you chose the applications you want to have installed: This is really easy, as long as you don’t want to install more than nine (9) applications in one step. The tenth … Continue reading →

SCCM 2012 Boost PXE deployments speed.

Hello guys! I’ve written about this subject before, but I’ve been getting some questions over the holidays...

Count of Local Printers

For more details, please see https://myitforum.com/Forums/tm.aspx?high=&m=240764&mpage=1#240768 select Distinct     PD.Name0,     count(*) from     dbo.v_GS_PRINTER_DEVICE PD Group by     PD.Name0 Order by     PD.Name0

Count of Local Printers

For more details, please see https://myitforum.com/Forums/tm.aspx?high=&m=240764&mpage=1#240768 select Distinct     PD.Name0,     count(*) from     dbo.v_GS_PRINTER_DEVICE PD Group by     PD.Name0 Order by     PD.Name0

Count of Local Printers

For more details, please see https://myitforum.com/Forums/tm.aspx?high=&m=240764&mpage=1#240768 select Distinct     PD.Name0,     count(*) from     dbo.v_GS_PRINTER_DEVICE PD Group by     PD.Name0 Order by     PD.Name0

Count of PC within each OU

For more detail about this query, please see http://www.windows-noob.com/forums/index.php?/topic/9069-report-count-of-computers-in-certain-organizational-units/ select ou.ou, count(*) as 'total' from (SELECT sys.ResourceID, max(OU.System_OU_Name0) AS 'OU' FROM dbo.v_R_System AS sys INNER JOIN dbo.v_RA_System_SystemOUName AS ou ON sys.ResourceID = ou.ResourceID GROUP BY sys.ResourceID) ou group by ou.ou Order by ou.ou

Count of PC within each OU

For more detail about this query, please see http://www.windows-noob.com/forums/index.php?/topic/9069-report-count-of-computers-in-certain-organizational-units/ select ou.ou, count(*) as 'total' from (SELECT sys.ResourceID, max(OU.System_OU_Name0) AS 'OU' FROM dbo.v_R_System AS sys INNER JOIN dbo.v_RA_System_SystemOUName AS ou ON sys.ResourceID = ou.ResourceID GROUP BY sys.ResourceID) ou group by ou.ou Order by ou.ou

Count of PC within each OU

For more detail about this query, please see http://www.windows-noob.com/forums/index.php?/topic/9069-report-count-of-computers-in-certain-organizational-units/ select ou.ou, count(*) as 'total' from (SELECT sys.ResourceID, max(OU.System_OU_Name0) AS 'OU' FROM dbo.v_R_System AS sys INNER JOIN dbo.v_RA_System_SystemOUName AS ou ON sys.ResourceID = ou.ResourceID GROUP BY sys.ResourceID) ou group by ou.ou Order by ou.ou

Finding all PCs with MSAcess.exe in the All Systems collection

Use this query to find all PCs with MS Access in the All systems collection.   select SMS_R_System.ResourceID, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_FullCollectionMembership on SMS_FullCollectionMembership.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "msaccess.exe" and SMS_FullCollectionMembership.CollectionID = 'SMS00001'

Finding all PCs with MSAcess.exe in the All Systems collection

Use this query to find all PCs with MS Access in the All systems collection.   select SMS_R_System.ResourceID, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_FullCollectionMembership on SMS_FullCollectionMembership.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "msaccess.exe" and SMS_FullCollectionMembership.CollectionID = 'SMS00001'

Finding all PCs with MSAcess.exe in the All Systems collection

Use this query to find all PCs with MS Access in the All systems collection.   select SMS_R_System.ResourceID, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_FullCollectionMembership on SMS_FullCollectionMembership.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "msaccess.exe" and SMS_FullCollectionMembership.CollectionID = 'SMS00001'