SCCM Configmgr report Count specific inventory file on computers

Full details:


select cs.Name0 [Computer name],COUNT(*) as [No of Times]
from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs
where FileName like '%.mdf%' and
group by cs.Name0
order by 2 desc

Leave a Reply

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