{"id":68143,"date":"2006-01-19T10:37:00","date_gmt":"2006-01-19T10:37:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2006\/01\/19\/how-can-i-tell-which-users-are-connected-to-a-print-queue\/"},"modified":"2006-01-19T10:37:00","modified_gmt":"2006-01-19T10:37:00","slug":"how-can-i-tell-which-users-are-connected-to-a-print-queue","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-tell-which-users-are-connected-to-a-print-queue\/","title":{"rendered":"How Can I Tell Which Users are Connected to a Print Queue?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I tell which users are connected to a print queue?

— RE<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, RE. You know, if your printers are anything like the ones the Scripting Guys are used to working with then it\u2019s easy to tell which users are connected to a print queue: all you have to do is walk into the printer room and see who\u2019s in there frantically looking in every nook and cranny for the document that the printer insists<\/I> it printed. At Microsoft the paperless office is very close to a reality. Not because we consciously set out to save paper, mind you, but because you typically have a better chance of hitting the jackpot in Las Vegas than you do of getting a document to actually print. <\/P>\n

If you have printers that are a tad bit more reliable than that, however, you might find it easier to use a script to determine which users are currently printing to a particular printer. There\u2019s a bit of a trick to doing this, and you have to use a slightly different approach to carry out this task on any version of Windows prior to Windows XP. But we\u2019ll explain all that in a moment. For now, let\u2019s take a look at a script that works on Windows XP and Windows Server 2003:<\/P>

strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colPrintJobs =  objWMIService.ExecQuery _\n    (“Select * From Win32_PrintJob Where Name Like ‘%FinancePrinter%'”)<\/p>\n
For Each objPrintJob in colPrintJobs \n    Wscript.Echo objPrintJob.Owner\nNext\n<\/PRE>\n
As you can see, there\u2019s not much to the script. It begins by connecting to the WMI service on the local computer (although the script could just as easily run against a remote machine). Here\u2019s where it gets a little tricky.<\/P>\n
As it turns out, the WMI class Win32_PrintJob<\/B> can return the logon name of all the users currently printing to all<\/I> the printers connected to a computer. Interestingly enough, however, Win32_PrintJob does not have a class that pinpoints which<\/I> print queue a user is connected to. At best, you can identify the printer using the Name<\/B> property. Values for this property are composed of two items: the name of the printer and a print job ID. For example, the print jobs currently in the queue for the printer FinancePrinter might look like this:<\/P>
FinancePrinter, 1\nFinancePrinter, 2\nFinancePrinter, 3\n<\/PRE>\n
Is that a problem? Yes, it is; after all, it prevents us from using a query like this to return all the print jobs in the FinancePrinter print queue:<\/P>
Set colPrintJobs =  objWMIService.ExecQuery _\n    (“Select * From Win32_PrintJob Where Name = ‘FinancePrinter'”)\n<\/PRE>\n
Why can\u2019t we use this query? Well, because there won\u2019t be<\/I> any print jobs with the Name FinancePrinter; instead, all the print jobs will be named things like FinancePrinter, 1<\/I>. How \u2026 delightful \u2026.<\/P>\n
But that\u2019s all right; as usual, we can work around WMI\u2019s idiosyncrasies. On Windows XP and Windows Server 2003 we can use the LIKE operator and a wildcard query, one that looks like this:<\/P>
Set colPrintJobs =  objWMIService.ExecQuery _\n    (“Select * From Win32_PrintJob Where Name Like ‘%FinancePrinter%'”)\n<\/PRE>\n
Note the construction of our Where clause: Where Name Like \u2018%FinancePrinter%\u2019<\/B>. The percent signs are our wildcard characters: they signify any character or set of characters, much the same way the asterisk does when used with the dir command. The command dir *.*<\/B> means, \u201cShow me all the files and folders whose names start with any character or set of characters, have a period in it, then end with any character or set of characters.\u201d Our WQL query can be read in similar fashion: \u201cBring back all the print jobs where the Name property starts with any character or set of characters, has the term FinancePrinter<\/I> in it, then ends with any character or set of characters.\u201d (And, yes, \u201cany character or set of characters\u201d also means no character at all.) In other words, bring back any print job where the Name includes the string FinancePrinter<\/I>.<\/P>\n
At that point all we have to do is set up a For Each loop and walk through the collection of print jobs, echoing back the value of the Owner<\/B> property for each one. The Owner property is the logon name of the connected user; for example, kmyer<\/B> or packerman<\/B>. That\u2019s the best you can do with Win32_PrintJob; if you need, say, the user\u2019s first and last name, you\u2019ll have to do something else. (One suggestion: take the logon name [also known as the sAMAccountName] and use it in an Active Directory search that can return the user\u2019s first and last name. For more information, see the Tales from the Script<\/I> column Dude, Where\u2019s My Printer?<\/B><\/A>)<\/P>\n
Now that\u2019s all well and good on Windows XP and Windows Server 2003; unfortunately, this script won\u2019t do much for anyone running an earlier version of Windows. That\u2019s because the LIKE operator isn\u2019t available on earlier version of Windows. That doesn\u2019t mean you\u2019re out of luck, it just means we have to do things the old-fashioned way. For example, instead of writing a query that returns only the print jobs being printed to FinancePrinter we need to write a query that returns all<\/I> the print jobs, regardless of printer:<\/P>
Set colPrintJobs =  objWMIService.ExecQuery _\n    (“Select * From Win32_PrintJob”)\n<\/PRE>\n
Once we have the entire collection of print jobs we can then use the InStr<\/B> function to determine whether or not the Name property includes the string FinancePrinter<\/I>:<\/P>
If Instr(objPrintJob.Name, “FinancePrinter”) Then\n<\/PRE>\n
It\u2019s a little more cumbersome, but it\u2019ll work. Here\u2019s a complete script that returns the list of users currently connected to a Windows 2000 print queue:<\/P>
strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colPrintJobs =  objWMIService.ExecQuery _\n    (“Select * From Win32_PrintJob”)<\/p>\n
For Each objPrintJob in colPrintJobs \n    If Instr(objPrintJob.Name, “FinancePrinter”) Then\n        Wscript.Echo objPrintJob.Owner\n    End If\nNext\n<\/PRE>\n
Unfortunately, we don\u2019t have a script that can tell you where printed documents actually go when the printer says<\/I> they were printed yet the printed pages are nowhere to be found. But we\u2019re working on it.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I tell which users are connected to a print queue?— RE Hey, RE. You know, if your printers are anything like the ones the Scripting Guys are used to working with then it\u2019s easy to tell which users are connected to a print queue: all you have to do is […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[712,523,404,713,3,4,5,6],"class_list":["post-68143","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-and-jobs","tag-print-servers","tag-printing","tag-queues","tag-scripting-guy","tag-scripting-techniques","tag-vbscript","tag-wmi"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I tell which users are connected to a print queue?— RE Hey, RE. You know, if your printers are anything like the ones the Scripting Guys are used to working with then it\u2019s easy to tell which users are connected to a print queue: all you have to do is […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=68143"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68143\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=68143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=68143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=68143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}