SQL – Page 13 – All about Microsoft Endpoint Manager

configmgr(SCCM) report for mismatch of computers in Configmr

Posted on January 3, 2010 by Eswar Koneti | 0 Comments | 163 Views

select CS.name0 as 'PC name', WS.LastHWScan as 'Last HW scan Date' from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_WORKSTATION_STATUS WS on CS.resourceID = WS.resourceID Where CS.resourceID not in (select R.resourceID from v_R_System R)

SCCM Configmgr delete retired orphaned distribution points

Posted on November 12, 2009 by Eswar Koneti | 3 Comments | 5,569 Views

I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed to DP but the distribution point are really not on the network (retired ).Because of this, I see the red alerts on the system status with below error. Possible cause: The distribution point might not…

SCCM Configmgr Patch Status Compliance software update report

Posted on October 16, 2009 by Eswar Koneti | 6 Comments | 2,973 Views

Are you looking for getting a report for a given KB numbers or MSID(like MS10-087),you can add few more lines to the existing code as like below and change the ID1 to ID2 also add a prompt to it.The same report is also applicable in SCCM but it doesn't give some columns though it has…

SCCM Configmgr Report for Software Update Compliance

Posted on September 25, 2009 by Eswar Koneti | 6 Comments | 2,115 Views

I was searching for something to find the software update complaince to see if machines requires something to patch .as i couldnt find any such report from default reports ,so created one like below and gives me the compelet complaicne of software updates. SQL Statement select distinct sys.Name0, ui.BulletinID as BulletinID, ui.ArticleID…

SCCM report for all advertisment with specific status plus patch compliance status ,other sccm reports

Posted on September 22, 2009 by Eswar Koneti | 0 Comments | 826 Views

In my daily work routine,i used to work with some of the web report to present it to management as well for troubleshooting purpose.I come across with many reports that are required.some reports that have taken from the internet. Here i am listing all of the reports that are useful and will be posting more…

SCCM Configmgr collection report how to check Group policy file updated or not for X days

Posted on July 15, 2009 by Eswar Koneti | 0 Comments | 3,149 Views

This gives list of machines where the group policy database file not updated .Before creating the SCCM web report,software inventory has to be enabled for GPO file secedit.sdb file which will is available in %windir%\security\database. collection(WQL): 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 where SMS_G_System_SoftwareFile.FileName =…

SCCM Report how to find collection hierarchy

Posted on July 15, 2009 by Eswar Koneti | 0 Comments | 3,611 Views

This Report will help you in identifying the collection that are member of any other parent collection. SELECT COL.CollectionID, COL.Name, COL.Comment, CTSC.parentCollectionID FROM dbo.v_Collection COL, dbo.v_CollectToSubCollect CTSC WHERE CTSC.subCollectionID = COL.CollectionID The above report is to get collection with its parent collection but if you want to know the root map of particular, go with…

SCCM report computers with Recently installed programs

Posted on July 14, 2009 by Eswar Koneti | 0 Comments | 1,414 Views

Gives list of computers where Programs installed recently. SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_INSTALLED_SOFTWARE ISW WHERE ISW.ResourceID = CS.ResourceID ORDER BY ISW.InstallDate0 DESC, CS.Name0, CS.UserName0, ISW.ProductName0