You might have different operating Systems installed on the computers.One fine day your boss might request you to get list…
Browsing: SQL
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 =…
I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed…
Are you looking for getting a report for a given KB numbers or MSID(like MS10-087),you can add few more lines…
I was searching for something to find the software update complaince to see if machines requires something to patch .as…
In my daily work routine,i used to work with some of the web report to present it to management as…
This gives list of machines where the group policy database file not updated .Before creating the SCCM web report,software inventory…
This Report will help you in identifying the collection that are member of any other parent collection. SELECT COL.CollectionID, COL.Name,…