Microsoft office with ip address of hostnames

Post Reply
admin
Site Admin
Posts: 12
Joined: 21 Feb 2016 14:15

Microsoft office with ip address of hostnames

Post by admin » 16 Apr 2018 11:05

Hi WQL script for
Microsoft office with ip address of hostnames,

select distinct SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version 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_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office St%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office 20%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office En%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office Prof%"



Post Reply