Apache WEB SERVER REPORT IN SCCM

Question

Hi,

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

Thanks,

Answer 1

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?

Answer 2

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.