Close Menu
    Facebook X (Twitter) Instagram
    Friday, May 16
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»ConfigMgr (SCCM)»SCCM Configmgr report Count specific inventory file on computers

    SCCM Configmgr report Count specific inventory file on computers

    Eswar KonetiBy Eswar KonetiNovember 01, 10:20 am1 Min Read ConfigMgr (SCCM) 3,155 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting

     

    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
    SF.ResourceID=cs.ResourceID
    group by cs.Name0
    order by 2 desc

    configmgr count file filename inventory report sccm report specific file SQL code
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Investigating Co-Management Issues with Windows Endpoints in SCCM/Intune

    October 26, 10:45 pm

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    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.