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.
