Close Menu
    Facebook X (Twitter) Instagram
    Monday, June 23
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report for Computers with IIS installed on servers

    SCCM report for Computers with IIS installed on servers

    Eswar KonetiBy Eswar KonetiMay 06, 1:24 am1 Min Read SCCM 2007 10,164 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Hi all ,Another report to find out the servers where IIS is installed with the version of it.this assumes that ,you have enabled the inventory agent and set the properties for .exe to not exclude windows folder.If you select exclude files from windows directory,you will not see any results in the report because inetmgr.exe will be located in windows folder.

    select distinct a.Name0,c.FileVersion from v_R_System a inner join
    v_GS_SERVICE b on b.ResourceID = a. ResourceID inner join
    v_GS_SoftwareFile c on c.ResourceID=a.ResourceID
    where b.DisplayName0 like 'World Wide Web%' and
    a.Operating_System_Name_and0 like '%Server%'  and
    c.FileName ='inetmgr.exe'
    Order by a.Name0,c.FileVersion 

    Configmgr 2007 configmgr report IIS installed report with IIS Role Installed SCCM 2007 SCCM report for Computers with IIS installed on servers
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    How to migrate standalone MBAM to SCCM for bitlocker

    November 10, 2:32 pm

    4 Comments

    1. David on June 20, 2019 4:38 AM

      Where do you run the report from?

      Reply
      • Eswar Koneti on July 4, 2019 4:02 PM

        I know the post is very old and was create in SCCM 2007 and software inventory works great there (filename) and faster but in CM12 and above, software inventory is very slow and takes hours to completed which is not good.
        You can make use of compliance baseline to create one CI to detect IIS .

        Thanks,
        Eswar

        Reply
        • Moses on November 17, 2022 11:53 PM

          Hi Eswar,
          It throws an error no such system v_R_System ?
          Is there a way you can correct the query?

          Reply
          • Eswar Koneti on January 14, 2023 5:01 PM

            Hi,
            can you post the screenshot of the error code? did you select the right database to run the query?

            Thanks,
            Eswar

            Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.