WQL用于获取最后一次登录用户为“office”属性的特定值的系统 [英] WQL for getting systems where last logon user is particular value for 'office' attribute

问题描述

我需要使用WQL在System Center Configuration Manager 2012 R2中为设备集合制定成员资格规则。我想获得最后一个登录用户具有'office'AD属性的给定值的所有设备。我被卡住了。



还有另一个问题我也无法上班，虽然我不明白为什么不这样做。此查询必须获取bios日期低于30/09/2008的所有系统。这是我试过的。

I need to make a membership rule for a device collection in System Center Configuration Manager 2012 R2, using WQL. I want to get all the devices where the last logon user has a given value for the 'office' AD attribute. I'm stuck.

There is another query I also can't get to work, though I don't understand why not. This query has to get all the systems where the bios date is under 30/09/2008. Here is what i tried.

SELECT SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, 
SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, 
SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client

from SMS_R_System inner join SMS_G_System_PC_BIOS 
on SMS_G_System_PC_BIOS.ResourceId = SMS_R_System.ResourceId

where SMS_G_System_PC_BIOS.ReleaseDate <= "30/09/2008 0:00:00"

推荐答案

这篇关于WQL用于获取最后一次登录用户为“office”属性的特定值的系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！