Solved

# Powershell Script help

Posted on 2015-02-09
118 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 Question by:Si Walton • 6 • 3 9 Comments LVL 69 Expert Comment 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 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 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


It gives the following output

Name     : PCBW180
UserName :

Name     : PCBW00013
UserName : DE-PROD\nimar
0

LVL 69

Accepted Solution

Qlemo earned 500 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" }} }

0

LVL 1

Author Comment

ID: 40598777
That works :)

Is there away to get the date/time stamp?

Thank you
0

LVL 1

Author Closing Comment

ID: 40598780
Quick and helpful thank you Qlemo
0

LVL 69

Expert Comment

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

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

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

Question has a verified solution.

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

### Suggested Solutions

This script checks a path to see if a folder exists. If the folder does exist you will get output "The folder has previously been created. No action taken" If not it will create the folder. Then adds one user modify permission to the folder. It …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

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

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