Thanks Easwar, but mentioned queries of no help, either directly or with some customization/adding with others...
Still looking for help.... From: [email protected] [mailto:[email protected]] On Behalf Of Eswar Koneti Sent: Tuesday, September 15, 2015 3:56 PM To: [email protected] Subject: RE: [mssms] SQL Query to get SCCM Servers list by Primary Site have you seen this ? http://eskonr.com/2014/01/configmgr-2012-ssrs-report-know-how-many-clients-assigned-to-management-points/ couple of SQL quires used in this to get the Primary and secondary info. Regards Eswar Koneti www.eskonr.com<http://www.eskonr.com> ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: [mssms] SQL Query to get SCCM Servers list by Primary Site Date: Tue, 15 Sep 2015 07:01:09 +0000 Hi, I use below query to get list of SCCM servers by the site it belongs, however currently it displays servers belongs to secondary site while my need is to list them by primary site they belong to, even if they are under/associated with secondary site ? how is that possible to do some sort of recursive stuff in query so secondary's are also linked and shown under respective primary ? select distinct site.reportingsitecode, site.sitecode, site.sitename, srl.servername from v_systemresourcelist srl join v_site site on site.sitecode=srl.sitecode order by 1 desc This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
