SCCM SQL如果安装了软件,则返回 [英] SCCM SQL Return if the software are installed or not
问题描述
伙计们,
我正在寻找一个SCCM SQL查询,如果一个集合安装了软件,则返回。
我现在有这个,但它为没有安装此应用程序的设备返回了很多值。你有意识形态吗?感谢您的帮助。
选择
SD.Name0'机器名',
SD.User_Name0'登录ID',
USR.Full_User_Name0'全名',
案例 ARP.DisplayName0 ='谷歌浏览器'然后'安装'ELSE'未安装'END AS'安装状态'
$
来自v_R_System SD
INNER JOIN v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = SD.ResourceID
内部加入v_FullCollectionMembership FCM on SD.ResourceID = FCM.ResourceID
内部加入v_Collection CN on FCM.CollectionID = CN.CollectionID
内部加入v_R_User USR on SD.User_Name0 = USR .User_Name0
内部加入v_Add_Remove_Programs ARP on SD.ResourceID = ARP.ResourceID
其中CN.CollectionID ='SMS00001'
嗨lgor,
感谢您在这里发帖。
根据您的描述,您似乎会喜欢使用SCCM SQL查询来检查软件是否按集合ID安装。
嗯,这里有一些SCCM SQL查询。您可以选择合适的一个来满足您的需求。
最好的问候,
将
Guys,
Im looking for a SCCM SQL Query to return if the software is installed or not by one Collection.
I have this one right now, but its returning a lot of values for the devices without this application installed. Do you have an ideia? Thanks for the help.
SD.Name0 'Machine Name',
SD.User_Name0 'Login ID',
USR.Full_User_Name0 'Full Name',
CASE WHEN ARP.DisplayName0 = 'Google Chrome ' THEN 'Installed' ELSE 'Not Installed' END AS 'Installation Status'
From v_R_System SD
INNER JOIN v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = SD.ResourceID
inner Join v_FullCollectionMembership FCM on SD.ResourceID = FCM.ResourceID
inner Join v_Collection CN on FCM.CollectionID = CN.CollectionID
inner Join v_R_User USR on SD.User_Name0 = USR.User_Name0
inner Join v_Add_Remove_Programs ARP on SD.ResourceID = ARP.ResourceID
Where CN.CollectionID = 'SMS00001'
Hi lgor,
Thanks for posting here.
Per your description, it seems that you would like to need a SCCM SQL Query for checking if the software is installed by collection ID.
Well, here are some SCCM SQL Query on this website. You could choose proper one to achieve your needs.
Best Regards,
Will
这篇关于SCCM SQL如果安装了软件,则返回的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!