Browse by Tags

• Active Directory
• Blogcasts
• Custom SMS Tools
• Downloads
• Miscellaneous
• Mr. Hand
• myITforum Articles
• Patch Configurations
• Personal Links
• Pinball Machines
• Systems Management
• The Blogcast Repository Newsletter
• Who am I?
• Windows

• Moving my Blog to my New Site

  If you have run across my blog searching for content, I am no longer here on myITforum. I will leave my posts in the hope that it helps someone looking... Posted Jan 30 2006, 11:31 PM by Anonymous with | with no comments Filed under: Personal Links, myITforum Articles, SMS SQL Queries, Systems Management, Active Directory, Pinball Machines, Who am I?, Windows, Miscellaneous, Custom SMS Tools, Blogcasts, Patch Configurations, Downloads, The Blogcast Repository Newsletter, Mr. Hand

• I can see that the cat is out of the bag....

  Ok, I have been talking about some site changes for The Blogcast Repository for a while now. However, for those who have asked, I have been providing links... Posted Nov 08 2005, 10:12 PM by Anonymous with | with 1 comment(s) Filed under: Personal Links, myITforum Articles, SMS SQL Queries, Systems Management, Active Directory, Who am I?, Windows, Miscellaneous, Custom SMS Tools, Blogcasts, Patch Configurations, Downloads, The Blogcast Repository Newsletter

• How to Install the SMS 2003 ITMU

  The documentation on the ITMU is fairly straight forward, but there is a lot to read and test. I decided to take some notes during the deployment and share... Posted Sep 13 2005, 10:47 AM by Anonymous with | with no comments Filed under: SMS SQL Queries, Systems Management, Patch Configurations, Downloads

• Query: System Information

  Paste this into your new query and it will list the computer name, domain / worksgroup name, user name, computer model, printers and printer ports, computer... Posted Dec 29 2004, 02:00 PM by Anonymous with | with no comments Filed under: SMS SQL Queries

• Basic SMS 2003 collection queries to Active Directory groups

  Interested in a few queries for AD users, computers and groups? Check out my article and see how easy it is! http://www.myitforum.com/blog/btucker/articles... Posted Dec 14 2004, 11:18 AM by Anonymous with | with no comments Filed under: SMS SQL Queries

• Query: Patch Install Successful - Reboot Required

  Most patches require a reboot and we configure the command line to do just that. However, sometimes the workstation or server does not reboot. For patches... Posted Dec 10 2004, 08:28 AM by Anonymous with | with no comments Filed under: SMS SQL Queries

• Query: All Advertisements to Sub-Collections

  You should keep tabs on which advertisements are sending packages to sub-collections. Why? Because sometimes an advertisement will be created and someone... Posted Dec 09 2004, 11:34 AM by Anonymous with | with no comments Filed under: SMS SQL Queries

• Query for SMS 2003 clients with Spyware

  Use this quesry to search for Spyware on all your workstations. I am sure this is not a complete list of everything out there, but will get you started... Posted Dec 06 2004, 03:08 PM by Anonymous with | with no comments Filed under: SMS SQL Queries

• Query to list all resources without a certain security patch

  Paste this into your query to see which machines are non-compliant for a certain patch. Add the QNumber where the red X is. select SMS_R_System.NetbiosName... Posted Dec 02 2004, 10:42 AM by Anonymous with | with no comments Filed under: SMS SQL Queries

• Query for "IS Obsolete" You need to have SMS 2003 SP1 installed

  Copy and paste the simple query below to list all your resources that are obsolete! The query will also give you the username of the person last logged... Posted Dec 01 2004, 10:30 PM by Anonymous with | with no comments Filed under: SMS SQL Queries

• A query that lists all computers with a specific patch installed

  I received an email today from Pat requesting a query that would list all machines that has a specific patch installed. Copy the SQL syntax below and paste... Posted Dec 01 2004, 09:43 PM by Anonymous with | with no comments Filed under: SMS SQL Queries