Apache WEB SERVER REPORT IN SCCM

Zeeshan sidd 1 Reputation point
2021-10-07T06:48:28.24+00:00

Hi,

I need SQL report in SCCM for Apcahe web (http server) installed in windows platform.

Thanks,

Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    2021-10-07T10:37:07.877+00:00

    What is wrong with the built in report for software inventory? What do you have for a sql query what isn't working for you?

    0 comments No comments

  2. Amandayou-MSFT 11,056 Reputation points
    2021-10-08T06:22:34.877+00:00

    Hi,

    We could try to use the following sql query to achieve it, please make changes to meet our requirement.

    Select Distinct  
     sys.Netbios_Name0,  
     sys.User_Domain0,  
     sys.User_Name0  
    FROM  
     v_R_System sys  
    JOIN v_Add_Remove_Programs arp  
     ON sys.ResourceID = arp.ResourceID  
    WHERE  
     sys.ResourceID in  
     (select sys.ResourceID  
     from  
     v_R_System sys  
     JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID  
     WHERE  
     DisplayName0 like '%displayname')  
    

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.