Jump to content


Search the Community

Showing results for tags 'wql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Cloud
    • Azure
    • Microsoft Intune
    • Office 365
  • General Stuff
    • General Chat
    • Events
    • Site News
    • Windows News
    • Suggestion box
    • Jobs
  • MDT, SMS, SCCM, Current Branch &Technical Preview
    • How do I ?
    • Microsoft Deployment Toolkit (MDT)
    • Official Forum Supporters
    • SMS 2003
    • Configuration Manager 2007
    • Configuration Manager 2012
    • System Center Configuration Manager (Current Branch)
    • Packaging
    • scripting
    • Endpoint Protection
  • Windows Client
    • how do I ?
    • Windows 10
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
    • windows screenshots
  • Windows Server
    • Active Directory
    • Microsoft SQL Server
    • System Center Operations Manager
    • KMS
    • Windows Deployment Services
    • NAP
    • Failover Clustering
    • PKI
    • Windows Server 2008
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Hyper V
    • Exchange
    • IIS/apache/web server
    • System Center Data Protection Manager
    • System Center Service Manager
    • System Center App Controller
    • System Center Virtual Machine Manager
    • System Center Orchestrator
    • Lync
    • Application Virtualization
    • Sharepoint
    • WSUS

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 6 results

  1. Running 1610, I stumbled across something yesterday, and I'm wondering if anyone else has seen this: changing just the name of a query used to populate a collection breaks the collection. Steps to replicate: Change the name of the query being used as a membership rule for a collection. Collection's icon gets an hourglass, even though nothing about its membership actually changed. Hourglass doesn't go away, and collection membership no longer updates. The first time I saw this was with a query-based collection looking for %server% in operatingSystemNameAndVersion. Ev
  2. Hi Our hardware inventory is extended to capture some registry values that contain company specific tags. However, on one of our images a value was missed (not present). I need to create a collection containing these machines, but I’m struggling to work out how to do this in WQL. Is it actually possible to use WQL to check if something does not exist (as opposed to being NULL)? Our environment is SCCM 2012 SP1 CU3. Thanks in advance.
  3. I am looking for a query that finds all computers joined to the domain since XX date. I tried using the query below which looks back over the last week for new computers but this also discovers any computers that have been modified in the last 7 days. Does anyone have a query that is based on date created? select SMS_R_System.Name, SMS_R_System.CreationDate FROM SMS_R_System WHERE DateDiff(dd,SMS_R_System.CreationDate, GetDate ()) <= 7
  4. Hi all, I'm looking for a way to collect and query on installed updates with SCCM 2012 SP1. I've tried using Win32_quickfixengineering but for for some reason not getting anything back. Any tips to achieve this? Thanks in advance. Nigel
  5. Hello. I'm having trouble making up a query for software metering. The query was adopted from some site and then modified to suit my purposes. I am however having problems adding a simple where-clause to this query. The query is as follows: Select SMS_R_System.ResourceID,SMS_R_System.Name,SMS_R_User.UniqueUserName FROM SMS_R_System JOIN SMS_UserMachineRelationship ON SMS_R_System.Name=SMS_UserMachineRelationship.MachineResourceName JOIN SMS_R_User ON SMS_UserMachineRelationship.UniqueUserName=SMS_R_User.UniqueUserName INNER JOIN SMS_G_System_SoftwareFile ON SMS_G_System_SoftwareFile.Res
  6. Hi there, WQL and SQL totally escapes me so I was wondering if someone could help. I'm after creating a report that will show users that have logged on to multiple machines and also list these machines... My Project manager asked spcifically for a report that displays users that have (in their possession) both a desktop and a laptop but I'm guessing my method would be easier. I believe you can also report on the primary user depending on the % of time a user has been logged on to a machine - maybe this could help narrow the results down further?? Hope someone can help - or
×
×
  • Create New...