For a specific Advertisement status for last 3 Days…
—for a specific Advertisement status for last 3 Days… if we include the Set @AdvName = ‘%’ line then and […]
All about Enterprise Mobility | Azure | MECM | SCCM | Intune
All about Enterprise Mobility | Azure | MECM | SCCM | Intune
—for a specific Advertisement status for last 3 Days… if we include the Set @AdvName = ‘%’ line then and […]
select CS.Name0, max(AD.AgentTime) as ‘Date/Time’ from dbo.v_AgentDiscoveries ad JOIN dbo.v_GS_COMPUTER_SYSTEM cs on AD.ResourceID = CS.ResourceId […]
read here more http://smsug.ca/blogs/garth_jones/archive/2008/12/03/how-to-add-ad-data-to-configmgr-reporting.aspx AD it just another database, just like SQL server is. With that in mind there is […]
Did you checked what is the log file of SCCM DB ? or did you checked what is the backup […]