Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Need help with a collection or Query

Posted on 2008-11-18
Medium Priority
Last Modified: 2013-11-21
I would like to create a collection or report that excludes deactivated computer accounts.  I copied over the all computers collection but could not find a variable to remove deactivated computer accounts.  

The goal is to see all active computer accounts so we can see what does not have the client installed.  

A second report that I will need to figure out is what computers do not have the client installed.
Question by:overflow34
  • 2

Accepted Solution

U_Mansson earned 1000 total points
ID: 22992390

You can do this using the attribute UserAccountControl in System Resource.

For example to query for all computers with disable accounts in AD:
select distinct SMS_R_System.Name from  SMS_R_System where SMS_R_System.UserAccountControl = "4098"

If you want all computers with enable accounts change the UserAccountControl to 4096

Author Comment

ID: 22995680
I receive an error when trying this.  I put the code into the query and was able to save without any errors.  When I right click and select run query I receive the error below.

Run Query

The following error was reported
Running the query:
select distinct SMS_R_System.Name from  SMS_R_System where SMS_R_System.UserAccountControl = "4098"

Author Comment

ID: 23085416
I also receive this when using 4096

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Boot PC and press F10, select storage options and change the compatibility from “AHCI” to “IDE”, save and exit 2. Boot PC and press F12 3. Upon PXE display of searching for DHCP server, press Pause break to obtain MAC address 3. Open Configu…
This is my 3rd article on SCCM in recent weeks, the 1st (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html) dealing with installat…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

576 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question