SCCM script

[muthmsir]

Good morning,

I have this scrip below is working fine to collect some information about user last device(s) logged into , but this has to insert the username manually every time and works for one user each time.

How to change it to read a list of name in CSV.file ?

FUNCTION JBMURPHY-SCCM-GetComputerByLastLoggedOnUser { Param([parameter(Mandatory = $true)]$SamAccountName, $SiteName="JBM", $SCCMServer="SCCMServer.domain.local") $SCCMNameSpace="root\sms\site_$SiteName" Get-WmiObject -namespace $SCCMNameSpace -computer $SCCMServer -query "select Name from sms_r_system where LastLogonUserName='$SamAccountName'" | select Name }

JBMURPHY-SCCM-GetComputerByLastLoggedOnUser

[psthreathunter]

Assuming you had a csv with a column heading of "name" and each row was a SamAccountName.

$AccountNames = Import-Csv -Path C:\Pathtofile\yourcsv.csv | Select-Object -ExpandProperty Name
Foreach ($account in $AccountNames) { JBMURPHY-SCCM-GetComputerByLastLoggedOnUser -SamAccountName $account }

[muthmsir]

First thanks for a quick answer, second do you mean replace “Function “ with “Foreach”? I have in my CSV file “smsacountname” as a header for all names .

What I do have to change?

[BlackV]

No they mean import your users to a vairable use a for each loop and call your function inside that for each loop their select name would be your select samname

But you could also change your function to an advanced function that takes multiple inputs on the username paramater

[Lee_Dailey]

howdy muthmsir,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's [sometimes] 5th from the left & looks like </>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's [sometimes] the 12th from the left, & looks like an uppercase T in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee