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

Senior IT Pro Trainer & Consultant focused on MS technologies relating to System Center Products SCCM, SCOM, SCO, SCSM