Adding user name to “Computers with a specific file” report

select
    SYS.Netbios_Name0,
    SYS.User_Name0,
    SF.FileName,
    SF.FileDescription,
    SF.FileVersion,
    SF.FileSize,
    SF.FileModifiedDate,
    SF.FilePath
From
    v_GS_SoftwareFile SF
    join v_R_System SYS on SYS.ResourceID = SF.ResourceID
Where
    SF.FileName LIKE @variable
ORDER BY
    SYS.Netbios_Name0

Leave a Reply

Your email address will not be published. Required fields are marked *