I have reserverd this Blog

I have reserverd this Blog

JAI HIND JAI HIND

               JAI H
               JAI HIN JA
                JAI HIND JAI HI
                  JAI HIND JAI H
                JAI HIND JAI HI
                 JAI HIND JAI
                 JAI HIND JAI
                   JAI HIND JAI
                   JAI HIND
                   JAI HIND J
                  JAI HIND JAI H
                JAI HIND JAI HIN
               JAI HIND JAI HIN                                  JAI H
             JAI HIND JAI HIND J                               JAI HIND J
            JAI HIND JAI HIND JAI H                 J         JAI HIND J
       JAI HIND JAI HIND JAI HIND JAI              JA     JAI HIND JAI
      JAI HIND JAI HIND JAI HIND JAI HIND J        JA      JAI HIND
       JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND JAI HIN
        JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND J JAI HIND JAI
         JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND  JAI HIND JAI
  JAI HI JAI HIND JAI HIND JAI HIND JAI HIND JAI HIN        JAI HI
 JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND      JAI H
     JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND JAI        JAI
    JAI HIND JAI HIND JAI HIND JAI HIND JAI HIND JAI HIN        J
     JAI HI JAI HIND JAI HIND JAI HIND JAI HIND JAI
      JAI H JAI HIND JAI HIND JAI HIND JAI HIND J
             JAI HIND JAI HIND JAI HIND JAI HIND
            JAI HIND JAI HIND JAI HIND JAI HIND
             JAI HIND JAI HIND JAI HIND JAI
             JAI HIND JAI HIND JAI HIND JAI
             JAI HIND JAI HIND JAI HIND J
             JAI HIND JAI HIND JAI HIND
             JAI HIND JAI HIND JAI HIN
              JAI HIND JAI HIND JAI HI
               JAI HIND JAI HIND JA
               JAI HIND JAI HIND J
                JAI HIND JAI HIN
                 JAI HIND JAI HIN
                 JAI HIND JAI HI
                  JAI HIND JAI H
                   JAI HIND JAI
                   JAI HIND JAI
                   JAI HIND JAI
                     JAI HIND
                     JAI HIN
                      JAI HI
                       JAI H
                        JAI

'VBS Script To Send A Remote Machines Hot Fix Information To Excel

'VBS Script To Send A Remote Machines Hot Fix Information To Excel
strComputer = InputBox ("Enter Machine Name")

 

Set objExcel = CreateObject("Excel.Application")

objExcel.Visible = True

objExcel.Workbooks.Add

intRow = 2

 

objExcel.Cells(1, 1).Value = "Machine Name"

objExcel.Cells(1, 2).Value = "Hot Fix ID"

objExcel.Cells(1, 3).Value = "Description"

objExcel.Cells(1, 4).Value = "Install Date"

 

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * from Win32_QuickFixEngineering Where HotFixID <> 'File 1'")

For Each objItem In colItems

objExcel.Cells(intRow, 1).Value = UCase(strComputer)

objExcel.Cells(intRow, 2).Value = objItem.HotFixId

objExcel.Cells(intRow, 3).Value = objItem.Description

objExcel.Cells(intRow, 4).Value = objItem.InstalledOn

 

intRow = intRow + 1

Next

 

objExcel.Range("A1:D1").Select

objExcel.Selection.Interior.ColorIndex = 19

objExcel.Selection.Font.ColorIndex = 11

objExcel.Selection.Font.Bold = True

objExcel.Cells.EntireColumn.AutoFit

 

MsgBox "Done"

 

Collection of Computers based on Users

Collection of Computers based on Users

 

SMS has a nice feature that allows you to create a collection based on users. That way when a users logs into a computer SMS will then run an advertisement for whatever computer they are on. The problem is maybe you want to have a collection of computers not the users. The worst flaw this the collection query I have created below and using collections based on users is that if a person logs in to another machine, for whatever reason, SMS will find them and push software to them.
That in mind, here is a collection that will take any OU group of users and create a collection of computers.


---------------------------------------
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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "xxxx /SECURITY USERS & GROUPS" )
--------------------------------------
Windows User account and group discovery must be enabled and run on your server to use this.

How does this work. It first grabs the list of users. Then matches them to the comptuers that SMS currently sees them logged into. To change this to Last Logged in user you need to change the SMS_G_System_Computer_System to SMS_R_System.LastLogonUserName for computers. This will give you last logged in user.

"Limit to Collection" for all your computer Workstations or further limit it to based on departments

If you don't know what group then you can create a query of just (select UniqueUserName from SMS_R_User where UserOUName = "") click values until you have the value you need and paste it into the larger query.
-------------------
Thanks,
http://sccm07.blogspot.com/

ALL MY recommendations to become a expert on 2k3 Server

Task 1	Links and comments
AD Basics	http://technet.microsoft.com/en-us/library/bb727169.aspx
AD basicthings to be know --Troubleshooting Active Directory	http://technet.microsoft.com/en-us/library/cc737561(WS.10).aspx
Common Windows Administrative Tasks	http://technet.microsoft.com/en-us/library/cc784837(WS.10).aspx
	Backing up and restoring data
	Changing group memberships
	Checking event logs
	Creating administrative scripts
	Creating logon scripts
	Creating user and group accounts
	Deploying and upgrading software
	Installing a DHCP server
	Installing a domain controller
	Managing applications on a local computer
	Managing applications remotely
	Managing directory replication
	Management tasks for disks and volumes
	File and folder management
	Managing network printers
	Managing servers remotely
	Managing services
	Monitoring network traffic
	Monitoring security-related events
	Monitoring server performance
	Resetting user passwords
	Safeguarding your system
	Scheduling tasks
	Setting up DNS
	Setting up TCP/IP
	Setting user and group security
AD FRS Basic and Troubleshooting	http://technet.microsoft.com/en-us/library/bb727056.aspx
Troubleshooting Active Directory Replication Problems	http://technet.microsoft.com/en-us/library/bb727057.aspx
	http://technet.microsoft.com/en-us/library/cc755349(WS.10).aspx
High-level Methodology for Troubleshooting Active Directory Problems	http://technet.microsoft.com/en-us/library/bb727053.aspx
Troubleshooting High CPU Usage on a Domain Controller	http://technet.microsoft.com/en-us/library/bb727054.aspx
Troubleshooting Active Directory—Related DNS Problems	http://technet.microsoft.com/en-us/library/bb727055.aspx
Performance and Reliability Monitoring	http://technet.microsoft.com/en-us/library/bb742467.aspx
System Recovery and Troubleshooting	http://technet.microsoft.com/en-us/library/bb742524.aspx
Manage Operations Master Roles	http://technet.microsoft.com/en-us/library/cc776474(WS.10).aspx
Securing Active Directory	http://technet.microsoft.com/en-us/library/cc728372(WS.10).aspx
How do you say AD and DNS integrated...What do you mean by this?	http://technet.microsoft.com/en-us/library/cc785656(WS.10).aspx
Understanding the Global Catalog	http://technet.microsoft.com/en-us/library/cc776756(WS.10).aspx
Understanding Sites and Replication and when to implement a site	http://technet.microsoft.com/en-us/library/cc757232(WS.10).aspx
Manage Forest Trusts & Creating	http://technet.microsoft.com/en-us/library/cc776217(WS.10).aspx
Manually publish a printer in Active Directory	http://technet.microsoft.com/en-us/library/cc736565(WS.10).aspx
Checklist: Creating a new Forest / New Domain / Child Domain Tree	http://technet.microsoft.com/en-us/library/cc787858(WS.10).aspx

Enjoy,

-Paddy

The Microsoft(R) Windows(R) Server 2003 Resource Tools

The Microsoft® Windows® Server 2003 Resource Tools

 

Acctinfo.dll (documented in Readme.htm)

Adlb.exe: Active Directory Load Balancing Tool

Admx.msi: ADM File Parser

Atmarp.exe: Windows ATM ARP Server Information Tool

Atmlane.exe: Windows ATM LAN Emulation Client Information

Autoexnt.exe: AutoExNT Service

Cdburn.exe: ISO CD-ROM Burner Tool

Checkrepl.vbs: Check Replication

Chklnks.exe: Link Check Wizard

Chknic.exe: Network Interface Card Compliance Tool for Network Load Balancing

Cleanspl.exe: Spooler Cleaner

Clearmem.exe: Clear Memory

Clusdiag.msi: Cluster Diagnostics and Verification Tool

Clusfileport.dll: Cluster Print File Port

Clusterrecovery.exe: Server Cluster Recovery Utility

Cmdhere.inf: Command Here

Cmgetcer.dll: Connection Manager Certificate Deployment Tool

Compress.exe: Compress Files

Confdisk.exe: Disk Configuration Tool

Consume.exe: Memory Consumers Tool

Creatfil.exe: Create File

Csccmd.exe: Client-Side Caching Command-Line Options

Custreasonedit.exe: Custom Reason Editor (documented in Readme.htm)

Delprof.exe: User Profile Deletion Utility

Dh.exe: Display Heap

Diskraid.exe: RAID Configuration Tool

Diskuse.exe: User Disk Usage Tool

Dnsdiag.exe: SMTP DNS Diagnostic Tool (documented in Readme.htm)

Dumpfsmos.cmd: Dump FSMO Roles

Dvdburn.exe: ISO DVD Burner Tool

Empty.exe: Free Working Set Tool

Eventcombmt.exe: Check Replication

Fcopy.exe: File Copy Utility for Message Queuing

Frsflags.vbs

Getcm.exe: Connection Manager Profile Update

Gpmonitor.exe: Group Policy Monitor

Gpotool.exe: Group Policy Objects

Hlscan.exe: Hard Link Display Tool

Ifilttst.exe: IFilter Test Suite

Ifmember.exe: User Membership Tool

Inetesc.adm: Internet Explorer Enhanced Security Configuration

Iniman.exe: Initialization Files Manipulation Tool

Instcm.exe: Install Connection Manager Profile

Instsrv.exe: Service Installer

Intfiltr.exe: Interrupt Affinity Tool

Kerbtray.exe: Kerberos Tray

Kernrate.exe: Kernel Profiling Tool

Klist.exe: Kerberos List

Krt.exe: Certification Authority Key Recovery

Lbridge.cmd: L-Bridge

Linkd.exe

Linkspeed.exe: Link Speed

List.exe: List Text File Tool

Lockoutstatus.exe: Account Lockout Status (documented in Readme.htm)

Logtime.exe

Lsreport.exe: Terminal Services Licensing Reporter

Lsview.exe: Terminal Services License Server Viewer

Mcast.exe: Multicast Packet Tool

Memmonitor.exe: Memory Monitor

Memtriage.exe: Resource Leak Triage Tool

Mibcc.exe: SNMP MIB Compiler

Moveuser.exe: Move Users

Mscep.dll: Certificate Services Add-on for Simple Certificate Enrollment Protocol

Nlsinfo.exe: Locale Information Tool

Now.exe: STDOUT Current Date and Time

Ntimer.exe: Windows Program Timer

Ntrights.exe

Oh.exe: Open Handles

Oleview.exe: OLE/COM Object Viewer

Pathman.exe: Path Manager

Permcopy.exe: Share Permissions Copy

Perms.exe: User File Permissions Tool

Pfmon.exe: Page Fault Monitor

Pkiview.msc: PKI Health Tool

Pmon.exe: Process Resource Monitor

Printdriverinfo.exe: Drivers Source

Prnadmin.dll: Printer Administration Objects

Qgrep.exe

Qtcp.exe: QoS Time Stamp

Queryad.vbs: Query Active Directory

Rassrvmon.exe: RAS Server Monitor

Rcontrolad.exe: Active Directory Remote Control Add-On

Regini.exe: Registry Change by Script

Regview.exe (documented in Readme.htm)

Remapkey.exe: Remap Windows Keyboard Layout

Robocopy.exe: Robust File Copy Utility

Rpccfg.exe: RPC Configuration Tool

Rpcdump.exe

Rpcping.exe

RPing: RPC Connectivity Verification Tool

Rqc.exe: Remote Access Quarantine Client

Rqs.exe: Remote Access Quarantine Agent

Setprinter.exe: Spooler Configuration Tool

Showacls.exe

Showperf.exe: Performance Data Block Dump Utility

Showpriv.exe: Show Privilege

Sleep.exe: Batch File Wait

Sonar.exe: FRS Status Viewer

Splinfo.exe: Print Spooler Information

Srvany.exe: Applications as Services Utility

Srvcheck.exe: Server Share Check

Srvinfo.exe: Remote Server Information

Srvmgr.exe: Server Manager

Ssdformat.exe: System State Data Formatter

Subinacl.exe

Tail.exe

Tcmon.exe: Traffic Control Monitor

Timeit.exe (documented in Readme.htm)

Timezone.exe: Daylight Saving Time Update Utility

Tsctst.exe: Terminal Server Client License Dump Tool

Tsscalling.exe: Terminal Services Scalability Planning Tools

Uddicatschemeeditor.exe: UDDI Services Categorization Scheme Editor

Uddiconfig.exe: UDDI Services Command-line Configuration Utility

Uddidataexport.exe: UDDI Data Export Wizard

Usrmgr.exe: User Manager for Domains

Vadump.exe: Virtual Address Dump

Vfi.exe: Visual File Information

Volperf.exe: Shadow Copy Performance Counters

Volrest.exe: Shadow Copies for Shared Folders Restore Tool

Vrfydsk.exe: Verify Disk

Winexit.scr: Windows Exit Screen Saver

Winhttpcertcfg.exe: WinHTTP Certificate Configuration Tool

Winhttptracecfg.exe: WinHTTP Tracing Facility Configuration Tool

Winpolicies.exe: Policy Spy

Wins.dll: WINS Replication Network Monitor Parser

Wlbs_hb.dll & Wlbs_rc.dll: Windows Load Balancing Server Network Monitor Parsers -------------------

Thanks,
http://sccm07.blogspot.com/

AD Basic checkout here

AD Basic checkout here

http://technet.microsoft.com/en-us/library/bb727169.aspx