I needed a SCCM report to count all enabled users in every domain. This is different to the builtin ‘Count users by domain’ as that one only lists domain users that have logged onto a system (that one is from v_R_System). Query = SELECT Windows_NT_Domain0, count(*) FROM v_R_User WHERE User_Account_Control0 = ’512′ GROUP BY Windows_NT_Domain0 [...]
- danovich.com.au -
Designing & deploying IT infrastructure in the enterprise
Categories
- AntiVirus (1)
- App-V (2)
- Certificates (4)
- Exchange (8)
- Geek (22)
- OCS / Lync (22)
- Opalis / Orchestrator (2)
- Scripting (30)
- Powershell (17)
- SMS / SCCM (77)
- Storage (4)
- Tools (47)
- VMWare (3)
- Windows (50)
Archive
- May 2012 (5)
- April 2012 (3)
- March 2012 (7)
- February 2012 (5)
- January 2012 (6)
- December 2011 (6)
- November 2011 (1)
- October 2011 (4)
- September 2011 (3)
- August 2011 (5)
- July 2011 (2)
- June 2011 (1)
- May 2011 (3)
- April 2011 (5)
- February 2011 (7)
- January 2011 (5)
- December 2010 (9)
- November 2010 (2)
- October 2010 (5)
- September 2010 (3)
- August 2010 (3)
- July 2010 (1)
- June 2010 (4)
- May 2010 (4)
- April 2010 (2)
- March 2010 (9)
- February 2010 (7)
- January 2010 (8)
- December 2009 (1)
- November 2009 (4)
- October 2009 (5)
- September 2009 (3)
- August 2009 (2)
- June 2009 (3)
- May 2009 (1)
- March 2009 (2)
- February 2009 (4)
- January 2009 (2)
- December 2008 (7)
Recommended Blogs
Tech Links
- Best Free Windows Software
- Dr Web online URL check
- Environment variables
- Live Mesh
- Microsoft Connect
- Microsoft Discussion Newsgroups
- Microsoft IPD
- Microsoft KB monitoring
- Microsoft TechNet Forums
- MX Lookup Tool
- NSLookup
- Online Script Decoder
- PortableApps
- Sendoid
- Speedtest
- SSL Certificate Check
- This blog's 2011 annual report
- TVCatchup.com
Random Quote
Pareto’s Principle, the 80/20 Rule, should serve as a daily reminder to focus 80 percent of your time and energy on the 20 percent of you work that is really important. Don’t just “work smart”, work smart on the right things.
Recent Entries
- SCCM report – Packages that have been updated since original content was distributed
- SCCM package containing a plus (+) sign / symbol in a filename
- PowerShell Scripts for System Center
- SCCM 2012 and client side BITS…
- SCCM 2012 Prerequisite Downloads
- SCCM 2012 Active Directory Schema changes
- How to tell which PXE/WDS server a machine booted from
- Change SCCM package source
- HP driver packages for SCCM
- Running multiple commands in SCCM ‘Run Command Line’ Task Sequence step
Recent Comments
- SiRu in HP iLO Integrated Remote Console is unavailable
- Andy in Windows 7 enable Recent Items via group policy
- danovich in PowerShell Scripts for System Center
- [SCCM 2012] PXE Boot in x86 or x64 Boot Images during SCCM OS deployment
- James in SCCM database size
- killragtshirts in Difference between IT architect roles
- Task sequence error– How to copy … in SCCM task sequence log file locations
- SCCM 2012 Active Directory Schema c… in SCCM Active Directory Schema changes
- danovich in List of recommended SCCM hotfixes
- danovich in Free online training for System Center 2012 includ…
Random Selection of Posts
- Extend the validity period of a Certificate Authority certificate
- Sysprep error – Setup was unable to change the password for user account Administrator
- Virtualization support for Microsoft products including SCCM, OCS, Exchange, ISA
- SCCM report to count hardware models
- chrome.exe – The application failed to initialize properly (0xc0000005)
- Windows 7 locks out domain account
- How to tell which PXE/WDS server a machine booted from
© 2009 - danovich.com.au - is proudly powered by WordPress.