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 remove the above line in red color will show for all advertisements with last 3 days status — To include all we need to give % in SQL this is a tip Declare     @AdvName Varchar(256)Set   … Read more

HeartBeat Discovery Status of specific collection of systems

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     join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = CS.ResourceId Where     AgentName = ‘Heartbeat Discovery’     and FCM.CollectionID = ‘SMS00001’ Group by     CS.Name0

AD computer Numbers vs SCCM Computer Numbers

read here more AD it just another database, just like SQL server is. With that in mind there is nothing stopping you from using SQL to link to AD to give you data about your AD environment! 1) Create Linked Server using SSMS exec master.dbo.sp_addlinkedserver ‘ADSI’, ‘Active Directory Service Interfaces’, ‘ADSDSOObject’, ‘<DC Name FQDN>’ … Read more