Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Powershell Script help

Posted on 2015-02-09
9
Medium Priority
?
129 Views
Last Modified: 2015-02-10
Hi

I need to check who is logged onto various Blade Workstation's using a Powershell Script and output to a text file so that we can then format the text file to HTML using Powershell

We use this to help Users see what Blades are available who is logged in if they require a certain Blade.

I have used a .bat file in the past and cleaned the output file in Powershell, But would like to clean up the process with just one script.

One issue I have found when looking online for a solution is the ability to have the UserName field show as "No Users" when No user is logged on.

We use the "No User" to assign a Blade is Free icon in the HTML page.

I have tried to use the eq $Null but have failed so far.

Requirements

Hostname
UserName + "No User"
Time logged in

Any help on finding a solution would be very much appreciated.

Thank you
0
Comment
Question by:Si Walton
  • 6
  • 3
9 Comments
 
LVL 72

Expert Comment

by:Qlemo
ID: 40598682
Can you provide more details how you do it now (e.g. the batch), and what you tried exactly?
0
 
LVL 1

Author Comment

by:Si Walton
ID: 40598689
Hi

We use the following batch file

winrs -r:pcbw177 hostname >> C:\Blades\UK\UK_Blades.txt  2>&1
Winrs -r:pcbw177 quser >> C:\Blades\UK\UK_Blades.txt  2>&1

It will provide the following to a txt file

PCBW00012
No User exists for *
PCBW00013
 USERNAME              SESSIONNAME        ID  STATE   IDLE TIME  LOGON TIME
 nimar                 console             3  Active      none   2/4/2015 2:52 PM

We then clean the txt file via Powershell
0
 
LVL 1

Author Comment

by:Si Walton
ID: 40598712
I have looked at many scripts but the below is close

Get-Content c:\myscripts\computers.txt | 
ForEach-Object {gwmi -computer $_ -class win32_computerSystem} | fl Name, UserName | 
out-file c:\myscripts\output8.txt

Open in new window


It gives the following output

Name     : PCBW180
UserName :

Name     : PCBW00013
UserName : DE-PROD\nimar
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 72

Accepted Solution

by:
Qlemo earned 2000 total points
ID: 40598752
Testing against $Null works for me. But we can also do it the other way round:
gwmi -computer (gc c:\temp\ee\computers.txt) Win32_ComputerSystem |
  select @{n='Blade'; e={$_.Name}},
         @{n='User'; e={ if ($_.UserName) { $_.Username } else { "No user" }} }

Open in new window

0
 
LVL 1

Author Comment

by:Si Walton
ID: 40598777
That works :)

Is there away to get the date/time stamp?

Thank you
0
 
LVL 1

Author Closing Comment

by:Si Walton
ID: 40598780
Quick and helpful thank you Qlemo
0
 
LVL 72

Expert Comment

by:Qlemo
ID: 40598805
Getting login time is more complex. You need to query Win32_LogonSession with the logon ID, which is associated to the name by another WMI object I cannot remember ...
0
 
LVL 1

Author Comment

by:Si Walton
ID: 40600427
Hi Qlemo

Login time isn't that important so it can be removed.

Is there away to have the USERNAME in Uppercase

DE-PROD\bendb = DE-PROD\BENDB

Thank you for your help with this, your time and effort is very much appreciated
0
 
LVL 1

Author Comment

by:Si Walton
ID: 40600725
any ideas how we can deal with the following error

Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

we have an issue with the Blade and it would be good to assign an "issue" symbol on the HTML page

Thank you
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
Welcome to 2018! Exciting things lie ahead in the world of tech. To start things off, we compiled great member articles on how to stay safe, ways to learn, and much more! Read on to start your new year right.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Loops Section Overview

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question