Ranganath2014
asked on
sql query
Hi ,
Need your help! i'm not a sql guy and dont want to get the following info from a query limited to a following collection:
In sccm 2012, i goto reporting - queries -> create query
select Distinct SMS_R_System.NetbiosName from SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PR OGRAMS on SMS_G_System_ADD_REMOVE_PR OGRAMS.Res ourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PR OGRAMS.Dis playName like "%adobe%") or SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PR OGRAMS_64 on SMS_G_System_ADD_REMOVE_PR OGRAMS_64. ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PR OGRAMS_64. DisplayNam e like "%adobe%") order by SMS_R_System.NetbiosName
the problem with this query is that it displays only computer names, i need the output in the below format:
Computer(s) Name App Name(that sccm has searched for)
Computer1, Computer3 Adobe Acrobat
Computer2, Computer4, computer1 Adobe Flash
Thanks in advance!
Regards,
Ranganath
Need your help! i'm not a sql guy and dont want to get the following info from a query limited to a following collection:
In sccm 2012, i goto reporting - queries -> create query
select Distinct SMS_R_System.NetbiosName from SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PR
the problem with this query is that it displays only computer names, i need the output in the below format:
Computer(s) Name App Name(that sccm has searched for)
Computer1, Computer3 Adobe Acrobat
Computer2, Computer4, computer1 Adobe Flash
Thanks in advance!
Regards,
Ranganath
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
(untested) try this:Open in new window