SCCM ile Detaylı Deployment raporu almak

Merhaba

SCCM ile Detaylı Deployment raporu almak için aşağıdaki sorguyu rapor haline getirebilir gelişmiş entegrasyon projelerinde kullanabilirsiniz.

SELECT a.Netbios_name0 as
‘Host Name’, a.Resource_Domain_OR_Workgr0,

site.sms_installed_sites0 as
‘Sitecode’,

a.Client0,

a.Obsolete0,

adv.AdvertisementName,

adv.AdvertisementID,

pkg.Name AS
‘Package Name’,

adv.ProgramName,

advstate.LastAcceptanceStatusTime,

advstate.LastAcceptanceStateName,

advstate.LastAcceptanceMessageIDname,

advstate.LastStatusmessageIDName,

advstate.LaststateName,

advstate.LastExecutionResult,

advstate.LastStatusTime,

advstate.LastExecutionContext,

adv.CollectionID,

col.Name

FROM v_Advertisement adv

INNER
JOIN v_Collection COL ON ADV.CollectionID = COL.CollectionID

INNER
JOIN v_Package pkg ON adv.PackageID = pkg.PackageID

INNER
JOIN v_ClientAdvertisementStatus advstate on adv.AdvertisementID=advstate.AdvertisementID

INNER
JOIN V_R_SYSTEM a ON a.Resourceid=advstate.resourceid

INNER
JOIN v_GS_WORKSTATION_STATUS HW ON a.resourceid=hw.resourceid

INNER
JOIN v_GS_LastSoftwareScan sw ON a.resourceid=sw.resourceid

LEFT
OUTER
JOIN v_RA_System_SMSInstalledSites site
ON a.resourceid=site.resourceid

 


Leave a Comment

Your email address will not be published. Required fields are marked *