PowerShell.com
Library » Script Library » Desktop » Slideshow

Desktop Slideshow

  1. <# 
  2. Script Name:  GetMappedNetworkPrinters.ps1 
  3.  
  4. Purpose: 
  5. This script can be used to collect the mapped network printer information from the users who are logged into the console of the Computer or Computers specified. 
  6.  
  7. Required Modules: 
  8. PSRemoteRegistry, and Active Directory 
  9.  
  10. Permission Requirements: 
  11. The user account that the script is run with needs to have administrative permissions on the workstations and permission to query Active Directory user accounts. 
  12. The computers firewall if enabled needs to allow it to be pinged, connections to WMI and also Remote Registry. 
  13. A user will need to be logged into the console so their mapped network printer information can be collected. 
  14.  
  15. How the script functions: 
  16. Create a text file that contains a list of Computer names that you want to get the mapped network printers info for. 
  17. Execute the script and you will be prompted for the path to the text file that contains the list. 
  18. Connectivity will be verified to each of the computers by pinging each of them. 
  19. Via WMI it will check to see which user is logged into the computers that responded to the ping. 
  20. Next it will query Active Directory for the SID of each of the users that were currently logged into one of the active computers polled. 
  21. Using the users SID a Remote Registry query is created to enumerate the list of mapped network printers for the logged on user. 
  22.  
  23. The Log files and CSV file containing the list of mapped printers is located in C:\temp\logs 
  24. FileNames: 
  25. MappedPrinters-(currentdate).csv -- Contains the list of mapped printers. 
  26. NoMappedPrinters-(currentdate).log -- Contains list of users that do not have network printers mapped on their computer. 
  27. NoReply-(currentdate).csv -- Contains list of computers that did not respond to ping. 
  28. NoUsrLoggedIn-(currentdate).log -- Contains list of computers that responded to ping but did not have a user logged into it. 
  29. RemoteRegNotRunning-(currentdate).log -- Contains a list of computers where the Remote Registry service is not running. 
  30. WmiError-(currentdate).log -- If there are computers that it is not able to connect to via wmi it will be listed here. 
  31. #> 
  32.  
  33.  
  34.  
  35. function global:Ping-Host {  
  36.     BEGIN { 
  37.          
  38.     } 
  39.         PROCESS { 
  40.         $results = gwmi -Query "SELECT * FROM Win32_PingStatus WHERE Address = '$_'" 
  41.         $obj2 = New-Object psobject 
  42.         $obj2 | Add-Member Noteproperty Computer $_ 
  43.         $obj2 | Add-Member Noteproperty IPAddress ($results.protocoladdress) 
  44.                  
  45.         if ($results.statuscode -eq 0) { 
  46.         $obj2 | Add-Member NoteProperty Responding $True 
  47.         } else { 
  48.         $obj2 | Add-Member NoteProperty Responding $False 
  49.     } 
  50.         Write-Output $obj2 
  51.          
  52.     } 
  53.     END {} 
  54.      
  55. } 
  56. function VerifyConnectivity { 
  57. param ( 
  58. [parameter(ValueFromPipeline=$true)] 
  59. $compList 
  60. ) 
  61. BEGIN { 
  62. $modeMSG = "Verifying Connectivity to Desktops" 
  63. $HostComputer = @() 
  64. $d = Get-Date 
  65. $strDate = $d.ToString() 
  66. $month = $d.Month 
  67. $day = $d.Day 
  68. $year = $d.Year 
  69. $cDate = "$month-$day-$year" 
  70. $logFilePath = "C:\temp\logs\" 
  71. $NoReplyLog = $logFilePath + "NoReply-" + $cDate + ".csv" 
  72. } 
  73. PROCESS { 
  74. $i = 1 
  75. $numComp = $compList.Count 
  76. If ($numComp -ge 1){ 
  77. Talk $modeMSG 
  78. $HostComputer = $HostComputer + $( 
  79.     foreach ($computer in $compList){ 
  80.     Write-Progress -Activity $modeMSG -Status "Currently Processing: $computer" -CurrentOperation "$i of $numComp" -PercentComplete ($i/$numComp*100) 
  81.     $computer | Ping-Host 
  82.     $i = $i + 1 
  83.  
  84. }) 
  85.  
  86. } 
  87. ElseIf ($numComp -lt 1){ 
  88. Write-Host "No Computers to Process" 
  89. Exit 
  90. } 
  91. } 
  92. END { 
  93. $Alive = $HostComputer | Where {$_.Responding -eq "$true"} 
  94. $global:Dead = $HostComputer | Where {$_.Responding -ne "$true"} 
  95. $global:Dead | select Computer | Export-Csv -Path $NoReplyLog 
  96. $Acomp = $Alive | select Computer 
  97. $Acomp 
  98. } 
  99.  
  100. } 
  101.  
  102. function GetPrinterInfo { 
  103. param ( 
  104. [parameter(ValueFromPipeline=$true)] 
  105. $compList 
  106. ) 
  107. BEGIN { 
  108. $d = Get-Date 
  109. $strDate = $d.ToString() 
  110. $month = $d.Month 
  111. $day = $d.Day 
  112. $year = $d.Year 
  113. $cDate = "$month-$day-$year" 
  114. $global:logFilePath = "C:\temp\logs\" 
  115. $NoPrtMapLog = $logFilePath + "NoMappedPrinters-" + $cDate + ".log" 
  116. $WmiErrorLog = $logFilePath + "WmiError-" + $cDate + ".log" 
  117. $MappedPrinters = $logFilePath + "MappedPrinters-" + $cDate + ".csv" 
  118. $NoUsrLoggedIn = $logFilePath + "NoUsrLoggedIn-" + $cDate + ".log" 
  119. $RemoteRegNotRunning = $logFilePath + "RemoteRegNotRunning-" + $cDate + ".log" 
  120. $ErrorActionPreference = 'SilentlyContinue' 
  121. Import-Module activedirectory 
  122. Import-Module psremoteregistry 
  123. $global:wmiErrors = @() 
  124. $global:NoUserLoggedIn = @() 
  125. $CompUserInfo = @() 
  126. $arrCompLogonInfo = @() 
  127. $arrRemoteRegSvcStopped = @() 
  128. $arrNoMappedPrinters = @() 
  129. $arrMappedPrinters = @() 
  130. $statusMSG = "Getting Logged on User Information" 
  131. $statusMSG2 = "Getting User SID from Active Directory" 
  132. $statusMSG3 = "Collecting Mapped Printer Information" 
  133. } 
  134. PROCESS { 
  135. $u = 1 
  136. $Responded = VerifyConnectivity $compList 
  137. if ($Responded.count -gt 0){ 
  138. Talk $statusMSG 
  139. foreach ($client in $Responded){ 
  140.     [string]$c = $client.Computer 
  141.     $numClient = $Responded.Count 
  142.     $logonInfo = $null 
  143.     Write-Progress -Activity $statusMSG -Status "Currently Processing: $c" -CurrentOperation "$u of $numClient" -PercentComplete ($u/$numClient*100)   
  144.     $logonInfo = Get-WmiObject -ComputerName $c -Query "select * from win32_computersystem" | select Username 
  145.     if ($?){ 
  146.         if ($logonInfo.Username -ne $null){ 
  147.             [string]$strUserName = $logonInfo.Username 
  148.             $arrStrUserName = $strUserName.Split("\") 
  149.             $strUser = $arrStrUserName[1]  
  150.             $objCUinfo = New-Object psobject 
  151.             $objCUinfo | Add-Member NoteProperty Workstation $c 
  152.             $objCUinfo | Add-Member NoteProperty User $strUser 
  153.             $CompUserInfo = $CompUserInfo + $objCUinfo             
  154.         } 
  155.         elseif ($logonInfo.Username -eq $null){ 
  156.         $global:NoUserLoggedIn = $global:NoUserLoggedIn + $c 
  157.         } 
  158.     } 
  159.     else { 
  160.         $global:wmiErrors = $global:wmiErrors + "Could not Execute WMI Query to collect user logon information on $c" 
  161.     } 
  162.     $u = $u + 1 
  163.     } 
  164.     if ($CompUserInfo.Count -ge 1){ 
  165.         $u = 1 
  166.         Talk $statusMSG2 
  167.         foreach ($logon in $CompUserInfo){ 
  168.         [string]$userLN = $logon.User 
  169.         $userCount = $CompUserInfo.count 
  170.         [string]$wrksta = $logon.Workstation 
  171.         Write-Progress -Activity $statusMSG2 -Status "Currently Processing: $userLN" -CurrentOperation "$u of $userCount" -PercentComplete ($u/$userCount*100) 
  172.         $getSID = Get-ADUser -Identity $userLN | select SID 
  173.         if ($?){ 
  174.             [string]$sid = $getSID.sid 
  175.             $LoggedOnUserInfo = New-Object psobject 
  176.             $LoggedOnUserInfo | Add-Member Noteproperty Workstation $wrksta 
  177.             $LoggedOnUserInfo | Add-Member Noteproperty User $userLN 
  178.             $LoggedOnUserInfo | Add-Member Noteproperty SID $sid 
  179.             $arrCompLogonInfo = $arrCompLogonInfo + $LoggedOnUserInfo 
  180.         } 
  181.         $u = $u + 1 
  182.         } 
  183.     } 
  184.     if ($arrCompLogonInfo.count -ge 1){ 
  185.         $u = 1 
  186.         Talk $statusMSG3 
  187.         foreach ($comp in $arrCompLogonInfo){ 
  188.         $numT = $arrCompLogonInfo.Count 
  189.         $Printers = $null 
  190.         [string]$cn = $comp.Workstation 
  191.         [string]$usid = $comp.sid 
  192.         [string]$uName = $comp.User 
  193.         Write-Progress -Activity $statusMSG3 -Status "Currently Processing: $cn" -CurrentOperation "$u of $numT" -PercentComplete ($u/$userCount*100) 
  194.         $regStat = Get-Service -ComputerName $cn -Name "RemoteRegistry" 
  195.         If ($?){ 
  196.             If ($regStat.Status -eq "Running"){ 
  197.                 $Printers =  Get-RegKey -ComputerName $cn -Hive "Users" -Key "$usid\Printers\Connections" -Recurse 
  198.                 If ($Printers -ne $null){ 
  199.                 foreach ($printer in $Printers){ 
  200.                 [string]$printerKey = $printer.key 
  201.                 $arrPrinterKey = $printerKey.Split("\") 
  202.                 $PrinterNamePiece = $arrPrinterKey[3] 
  203.                 $arrPrinterParts = $PrinterNamePiece.Split(",") 
  204.                 $printServer = $arrPrinterParts[2] 
  205.                 $PrinterName = $arrPrinterParts[3] 
  206.                 $PrinterUnc = "\\$printServer\$PrinterName" 
  207.                 $printInfo = New-Object psobject 
  208.                 $printInfo | Add-Member NoteProperty Workstation $cn 
  209.                 $printInfo | Add-Member NoteProperty User $uName 
  210.                 $printInfo | Add-Member NoteProperty PrintServer $printServer 
  211.                 $printInfo | Add-Member NoteProperty PrinterName $PrinterName 
  212.                 $printInfo | Add-Member NoteProperty PrinterUNC $PrinterUnc 
  213.                 $arrMappedPrinters = $arrMappedPrinters + $printInfo 
  214.                 } 
  215.                 } 
  216.                 ElseIf ($Printers -eq $null){ 
  217.                     $arrNoMappedPrinters = $arrNoMappedPrinters + "$uName has no mapped printers on $cn" 
  218.                     } 
  219.             } 
  220.             ElseIf ($regStat.Status -eq "Stopped"){ 
  221.                 $arrRemoteRegSvcStopped = $arrRemoteRegSvcStopped + $cn 
  222.             } 
  223.         } 
  224.         $u = $u + 1 
  225.         } 
  226.      
  227.      
  228.     } 
  229.      
  230. } 
  231. } 
  232. END { 
  233.     $arrMappedPrinters | Export-Csv -Path $MappedPrinters 
  234.     Add-Content $NoPrtMapLog $arrNoMappedPrinters 
  235.     Add-Content $WmiErrorLog $wmiErrors 
  236.     Add-Content $NoUsrLoggedIn $global:NoUserLoggedIn 
  237.     Add-Content $RemoteRegNotRunning $arrRemoteRegSvcStopped 
  238.     } 
  239. } 
  240.  
  241. function Talk { 
  242. param ( 
  243. [parameter(ValueFromPipeline=$true)] 
  244. $talk 
  245. ) 
  246. Add-Type -AssemblyName System.Speech 
  247. $synthesizer = New-Object -TypeName System.Speech.Synthesis.SpeechSynthesizer 
  248. $synthesizer.Speak($talk) 
  249.  
  250. } 
  251.  
  252. cls 
  253. $getPath = $(Read-Host "Enter path to the text file that contains the list of Computer Names`n") 
  254. cls 
  255. if ($getPath -like "*.txt"){ 
  256.     $valid = Test-Path -Path $getPath 
  257.     if ($valid -eq $true){ 
  258.         $compList = get-content -Path $getPath  
  259.         GetPrinterInfo $compList 
  260.         Write-Host "The Script Output is located in $logfilepath" 
  261.         Exit 
  262.  
  263.     } 
  264.  
  265.     Else { 
  266.     Write-Host "Path to file is not valid" -ForegroundColor Red 
  267.     } 
  268. } 
  269. Elseif ($getPath -notlike "*.txt"){ 
  270.     Write-Host "Path to file is not valid" 
  271.     Exit 
  272. } 
 
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.