PowerShell.com
Library » Script Library » System Center Configuration Manager » Slideshow

System Center Configuration Manager Slideshow

  1. function sccmuser ($user){ 
  2. $server= "." 
  3. $database = "." 
  4. $sccmsql1 = "SELECT  SYS.User_Name0, SYS.Netbios_Name0, SYS.User_Domain0, 
  5. Operating_System_Name_and0, SYS.Resource_Domain_OR_Workgr0  
  6. from v_R_System SYS 
  7. where User_Name0 LIKE '$user' 
  8. ORDER BY SYS.User_Name0, SYS.Netbios_Name0" 
  9. $sccm= Invoke-Sqlcmd -query $sccmsql1 -serverinstance $server -database $database 
  10. $sccm | Select-Object -first 3 
  11. } 
 
Loading...
View all files
Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.