Client Management Suite

 View Only

  • 1.  Repport to show Server with IIS

    Posted Aug 17, 2016 08:04 AM

    Hi I need help please in providing a report that shows which servers we have that are running IIS on our environment, can this be done and if so how to achive this?

    I have been trying to use cubes but not getting the info I need.



  • 2.  RE: Repport to show Server with IIS

    Broadcom Employee
    Posted Aug 17, 2016 09:45 AM

    Hi,

    SQL query below should return the list of the computers with IIS service installed:

    SELECT DISTINCT vc.[Name]
FROM [dbo].[vComputerIdentification] vc
	JOIN [dbo].[Inv_AeX_AC_NT_Services] svcs 
	ON 
		svcs.[_ResourceGuid] = vc.[Guid] 
		AND 
		UPPER( svcs.[Name] ) = 'W3SVC'

    HTH,

    Alex.