—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
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
read here more https://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 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
Did you checked what is the log file of SCCM DB ? or did you checked what is the backup size and why it is increasing ? Yes it is because of transaction log size increase … check below query to know the size of the log files…. SELECT name,size from … Read more
