Bonjour
pour IIS MA Query mais dommage l'info du service started n'est pas communiquée
select SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_G_System_SERVICE.Status, SMS_G_System_SERVICE.StartMode from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IPAddresses
like "%10.10%" and SMS_G_System_SERVICE.DisplayName like "%IIS%"
pour mysql
select SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IPAddresses
like "%10.10.%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%MySQL%"
j'ai trouvé aussi le reporting de IIS
http://eskonr.com/2010/05/sccm-report-for-computers-with-iis-installed-on-servers/
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
Je cherche tjr l'apache et oracle en cas ou
merci
Share to advance
