"Announcing System Center Configuration Manager 2007 R3
Today, the System Center team is excited to share with you our plan to release System Center Configuration Manager 2007 R3. This new release of the ConfigMgr is packed with some extremely cool features, which over the coming months we plan to share with you in different ways.
Recent shifts in the world economy have brought new focus on IT departments, and also to technology investment. Organizations are being pressured to do more with less, while at the same time manage an increasing range of working scenarios, mobility requirements, and business demands. Through all of this, they need to maintain security levels, answer compliance challenges and address the growing Green IT landscape.
As organizations look to reduce financial costs and environmental impacts, power management is proving to be a successful approach. The payback for power management is clear – when a PC is using less power it translates directly into reduced operational costs – either directly through reduced energy consumption or from a growing number of electrical companies that offer rebates to companies that can prove enforcement of centralized power management policies. In addition, continuous PC power management pays environmental dividends measured in terms like Kwh, or CO2 emissions savings.
Forrester estimates that more than 90% of firms are implementing or considering PC power management. Despite the advanced capabilities provided in Windows Vista and Windows 7, The U.S. Environmental Protection Agency estimates that no more than 10% of all enterprise PCs in use have their power management capabilities turned on today. Without centra"
ConfigMgr Learn it and work it
28 September 2009
SCCM 2007 R3
"Announcing System Center Configuration Manager 2007 R3
Today, the System Center team is excited to share with you our plan to release System Center Configuration Manager 2007 R3. This new release of the ConfigMgr is packed with some extremely cool features, which over the coming months we plan to share with you in different ways.
Recent shifts in the world economy have brought new focus on IT departments, and also to technology investment. Organizations are being pressured to do more with less, while at the same time manage an increasing range of working scenarios, mobility requirements, and business demands. Through all of this, they need to maintain security levels, answer compliance challenges and address the growing Green IT landscape.
As organizations look to reduce financial costs and environmental impacts, power management is proving to be a successful approach. The payback for power management is clear – when a PC is using less power it translates directly into reduced operational costs – either directly through reduced energy consumption or from a growing number of electrical companies that offer rebates to companies that can prove enforcement of centralized power management policies. In addition, continuous PC power management pays environmental dividends measured in terms like Kwh, or CO2 emissions savings.
Forrester estimates that more than 90% of firms are implementing or considering PC power management. Despite the advanced capabilities provided in Windows Vista and Windows 7, The U.S. Environmental Protection Agency estimates that no more than 10% of all enterprise PCs in use have their power management capabilities turned on today. Without centra"
Today, the System Center team is excited to share with you our plan to release System Center Configuration Manager 2007 R3. This new release of the ConfigMgr is packed with some extremely cool features, which over the coming months we plan to share with you in different ways.
Recent shifts in the world economy have brought new focus on IT departments, and also to technology investment. Organizations are being pressured to do more with less, while at the same time manage an increasing range of working scenarios, mobility requirements, and business demands. Through all of this, they need to maintain security levels, answer compliance challenges and address the growing Green IT landscape.
As organizations look to reduce financial costs and environmental impacts, power management is proving to be a successful approach. The payback for power management is clear – when a PC is using less power it translates directly into reduced operational costs – either directly through reduced energy consumption or from a growing number of electrical companies that offer rebates to companies that can prove enforcement of centralized power management policies. In addition, continuous PC power management pays environmental dividends measured in terms like Kwh, or CO2 emissions savings.
Forrester estimates that more than 90% of firms are implementing or considering PC power management. Despite the advanced capabilities provided in Windows Vista and Windows 7, The U.S. Environmental Protection Agency estimates that no more than 10% of all enterprise PCs in use have their power management capabilities turned on today. Without centra"
System Center Configuration Manager 2007 | “Announcing System Center Configuration Manager 2007 R3” - Blog de Aurélien BONNIN [EXAKIS]
System Center Configuration Manager 2007 R3
There are a few areas of focus for ConfigMgr R3, with the main engineering effort concentrating on Power Management. Here are the goals for this feature:
Power Management
The goal of this capability is to enable Configuration Manager to further reduce the operational costs of IT by providing basic power management features native to the product. Our approach is based on 3 primary areas:
A. Help the organization plan a power strategy by monitoring current power state and consumptions and reporting on machine utilization trends, current power settings and current energy consumption
B. Enable the Administrator to easily create, deploy and enforce specific power settings using the existing ConfigMgr infrastructure
−Ability to set peak and non-peak schedules
−Ability to remediate settings if changed
−Ability to opt out machines from power policy
C. Provide the business meaningful report formats that are relevant to Power Management
An effective approach to power management needs to maximize power policy deployment while minimizing the impact to the end-user. System Center Configuration Manager helps customers further reduce their operational costs by adding new in box capability to their ConfigMgr infrastructure, and by seamlessly enabling power management client agent services to their existing Collection landscape.
In addition to power management, ConfigMgr R3 will provide customers with enhanced scale and performance support above current numbers.
There are a few areas of focus for ConfigMgr R3, with the main engineering effort concentrating on Power Management. Here are the goals for this feature:
Power Management
The goal of this capability is to enable Configuration Manager to further reduce the operational costs of IT by providing basic power management features native to the product. Our approach is based on 3 primary areas:
A. Help the organization plan a power strategy by monitoring current power state and consumptions and reporting on machine utilization trends, current power settings and current energy consumption
B. Enable the Administrator to easily create, deploy and enforce specific power settings using the existing ConfigMgr infrastructure
−Ability to set peak and non-peak schedules
−Ability to remediate settings if changed
−Ability to opt out machines from power policy
C. Provide the business meaningful report formats that are relevant to Power Management
An effective approach to power management needs to maximize power policy deployment while minimizing the impact to the end-user. System Center Configuration Manager helps customers further reduce their operational costs by adding new in box capability to their ConfigMgr infrastructure, and by seamlessly enabling power management client agent services to their existing Collection landscape.
In addition to power management, ConfigMgr R3 will provide customers with enhanced scale and performance support above current numbers.
System Center Configuration Manager 2007 | “Announcing System Center Configuration Manager 2007 R3” - Blog de Aurélien BONNIN [EXAKIS]
System Center Configuration Manager 2007 R3
There are a few areas of focus for ConfigMgr R3, with the main engineering effort concentrating on Power Management. Here are the goals for this feature:
Power Management
The goal of this capability is to enable Configuration Manager to further reduce the operational costs of IT by providing basic power management features native to the product. Our approach is based on 3 primary areas:
A. Help the organization plan a power strategy by monitoring current power state and consumptions and reporting on machine utilization trends, current power settings and current energy consumption
B. Enable the Administrator to easily create, deploy and enforce specific power settings using the existing ConfigMgr infrastructure
−Ability to set peak and non-peak schedules
−Ability to remediate settings if changed
−Ability to opt out machines from power policy
C. Provide the business meaningful report formats that are relevant to Power Management
An effective approach to power management needs to maximize power policy deployment while minimizing the impact to the end-user. System Center Configuration Manager helps customers further reduce their operational costs by adding new in box capability to their ConfigMgr infrastructure, and by seamlessly enabling power management client agent services to their existing Collection landscape.
In addition to power management, ConfigMgr R3 will provide customers with enhanced scale and performance support above current numbers.
There are a few areas of focus for ConfigMgr R3, with the main engineering effort concentrating on Power Management. Here are the goals for this feature:
Power Management
The goal of this capability is to enable Configuration Manager to further reduce the operational costs of IT by providing basic power management features native to the product. Our approach is based on 3 primary areas:
A. Help the organization plan a power strategy by monitoring current power state and consumptions and reporting on machine utilization trends, current power settings and current energy consumption
B. Enable the Administrator to easily create, deploy and enforce specific power settings using the existing ConfigMgr infrastructure
−Ability to set peak and non-peak schedules
−Ability to remediate settings if changed
−Ability to opt out machines from power policy
C. Provide the business meaningful report formats that are relevant to Power Management
An effective approach to power management needs to maximize power policy deployment while minimizing the impact to the end-user. System Center Configuration Manager helps customers further reduce their operational costs by adding new in box capability to their ConfigMgr infrastructure, and by seamlessly enabling power management client agent services to their existing Collection landscape.
In addition to power management, ConfigMgr R3 will provide customers with enhanced scale and performance support above current numbers.
14 August 2009
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
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
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
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"
'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"
11 August 2009
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/
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/
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/
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/
Subscribe to:
Posts (Atom)