Dashboard with Powershell

Building a Dashboard

Goal
Show Status of production assets grouped in kits.


Using our asset management system's data and PowerShell

Asset Management System
https://www.ezofficeinventory.com/developers
Universal Dashboard for PowerShell
https://docs.universaldashboard.io/

Setup
Update PowerShell
Find-Module -Name PowerShellGet | Install-Module
Install UniversalDashboard.Community Version 2.3.2
Install-Module UniversalDashboard.Community -MaximumVersion 2.3.2

Folder Structure
C:\Support\scripts\dashboard
          - data   # XML data stored here
          - pages # Dashboard pages
          - modules # modules that pull and format data


TLS Error - Older versions of Windows may need TLS1.2 enabled.

[System.Net.ServicePointManager]::SecurityProtocol = `
[System.Net.SecurityProtocolType]::Tls12;

Get Assets  - get-ezoffice-assets.ps1

$token="mykeyguid"

$baseuri="https://mydomain.ezofficeinventory.com"

$method="/assets.api"

$senduri=$baseuri+$method

$pages=0

$assets=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

$pages=$assets.total_pages

$allassets=@()

$curpage=1

While($curpage -le $pages){

# $curpage

$senduri=$baseuri+$method+"?page="+$curpage

$assets=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

$curpage++

$allassets = $allassets + $assets.assets

}

#$allassets.count

$allassets |Export-Clixml -Path C:\support\scripts\dashboard\data\assets.xml

Get Group Data - get-ezoffice-groups.ps1

$token="mykeyguid"

$baseuri="https://mydomain.ezofficeinventory.com"

$method="/assets/classification_view.api"

$senduri=$baseuri+$method

$pages=0

$groups =@{}

$groups=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

$pages=$groups.total_pages

#$pages

$allgroups=@()

$curpage=1

While($curpage -le $pages){

$senduri=$baseuri+$method+"?page="+$curpage

$groups=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

$curpage++

$allgroups = $allgroups + $groups.groups.group

}

$allgroups |Export-Clixml -Path C:\support\scripts\dashboard\data\groups.xml

Build display data with data from EZoffice Inventory - get-ezoffice-bundles.ps1

$token="mykeyguid"

$baseuri="https://mydomain.ezofficeinventory.com"

$method="/bundles.api"

$senduri=$baseuri+$method

###############################

### Get All bundles from EzOfficeInventory

###############################

$pages=0

$bundles =@{}

$bundles=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

$pages=$bundles.total_pages

$allbundles=@()

$curpage=1

While($curpage -le $pages){

$senduri=$baseuri+$method+"?page="+$curpage

$bundles=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

$curpage++

$allbundles = $allbundles + $bundles.bundles

}

####### Save Bundles to XML file

$allbundles|Export-Clixml -Path C:\support\scripts\dashboard\data\bundles.xml

###############################

### Load Group and Asset data

###############################

$assetDataPath = "C:\support\scripts\dashboard\data\assets.xml"

$groupsDataPath = "C:\support\scripts\dashboard\data\groups.xml"

$locationsDataPath = "C:\support\scripts\dashboard\data\locations.xml"

#

$assets = @{}

$groups = @{}

$locations = @{}

$ghash=@{} #groups hash table

#

$assets = import-Clixml -Path $assetDataPath

$groups = import-Clixml -Path $groupsDataPath

$groups|Where-Object{$ghash.add($_.id,$_.name)} # Convert goups to hash table

$locations = import-Clixml -Path $locationsDataPath

###############################

###############################

# Build Bundle Items XML

###############################

$bundleData = @{}

[System.Collections.ArrayList]$bundleItems = @{}

$allbundles|ForEach-Object{

$method="/bundles/" + $_.id + ".api"

$senduri=$baseuri+$method

$bundleData=Invoke-RestMethod -H @{"token" = $token} -Method GET -URI $senduri

#$KitAssets = @{}

$bundleData.bundle.line_item_labels.GetEnumerator()|ForEach-Object {

$TassetID=$_.Replace("Asset #","").split(' ')[0]

$ta=@{}

$ta = $assets | Where-Object {$_.sequence_num -eq $TassetID}

$KitAsset = [pscustomobject]@{

Name = $ta| Select-Object -ExpandProperty name

Identifier = $ta| Select-Object -ExpandProperty identifier

State = $ta| Select-Object -ExpandProperty state

User = $ta| Select-Object -ExpandProperty assigned_to_user_name

AssetID = $TassetID

Description = $ta| Select-Object -ExpandProperty description

}

$Items = [pscustomobject]@{

bundleID = $bundleData.bundle.id

assetID = $_.Replace("Asset #","").split(' ')[0]

Asset = $KitAsset#$a1 +"/"+ $a3 +"/"+ $a2

}

$bundleItems.add($Items)|Out-Null

}

}

$bundleItems|Export-Clixml -Path C:\support\scripts\dashboard\data\bundleItems.xml

###############################

# Build Kits Display Data XML

###############################

$KitsDisplay = Foreach ($row in $allbundles)

{

[pscustomobject]@{

KitName = $row.name

State = $locations | Where-Object {$_.id -eq $row.location_id} |Select-Object -ExpandProperty state

Assets = $bundleItems| Where-Object {$_.bundleID -eq $row.id} | Select-Object -ExpandProperty Asset

}

}

$KitsDisplay |Export-Clixml -Path C:\support\scripts\dashboard\data\KitsDisplay.xml

Kits Dashboard page - kits.ps1

#

#

# Kits Page

#

New-UDPage -AutoRefresh -RefreshInterval 60 -Name 'Kits' -Icon cloud -Content {

###############################

### Load Group and Asset data

###############################

$KitsData = "C:\support\scripts\dashboard\data\KitsDisplay.xml"

$Global:kitdata =$null

$Global:kitname =$null

#

$kits= @{}

$kits = import-Clixml -Path $KitsData

###############################

$myBGColor=@{

available = "white" 

maintenance = "orange"

}

$TblStyle = "

<style>

TABLE{border-width: 2px;border-style: solid;border-color: black;border-collapse: collapse;}

TH{border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color:#778899}

TD{border-width: 1px;padding: 3px;border-style: solid;border-color: black;}

</style>

"

New-UDRow {

    New-UDColumn {

New-UDCard -Content {"Nevada"} -BackgroundColor blue -FontColor white

$kits |Where-Object {$_.State -eq 'NV'} |ForEach-Object {

$Tbl=$TblStyle

#tr:nth-child(odd) { background-color:#d3d3d3;}

#tr:nth-child(even) { background-color:white;}

$Tbl=$Tbl+"<table> <tr><th>"+ $_.KitName + "</th></tr>"

$_.Assets|ForEach-Object {

$Thref = "https://mydomain.ezofficeinventory.com/assets/"+$_.AssetID

$Ttitle = $_.Description # Displayed in with mouseover hover

$Tbl=$Tbl+ '<tr bgcolor="'+$myBGColor[$_.State]+'"><td> <a href="'+$Thref+'" title="'+$Ttitle+'" target="_blank">' + $_.Name + '</td></tr>'

}

$Tbl=$Tbl+ "</table>"

New-UDHtml -Markup $Tbl

}

} ### - End UDColumn

New-UDColumn {

         New-UDCard -Content {"Arizona"} -BackgroundColor blue -FontColor white

    

$kits |Where-Object {$_.State -eq 'AZ'} |ForEach-Object {

$Tbl=$TblStyle

#tr:nth-child(odd) { background-color:#d3d3d3;}

#tr:nth-child(even) { background-color:white;}

$Tbl=$Tbl+"<table> <tr><th>"+ $_.KitName + "</th></tr>"

$_.Assets|ForEach-Object {

$Thref = "https://mydomain.ezofficeinventory.com/assets/"+$_.AssetID

$Ttitle = $_.Description

$Tbl=$Tbl+ '<tr bgcolor="'+$myBGColor[$_.State]+'"><td> <a href="'+$Thref+'" title="'+$Ttitle+'" target="_blank">' + $_.Name + '</td></tr>' }

$Tbl=$Tbl+ "</table>"

New-UDHtml -Markup $Tbl

}

}### - End UDColumn

    New-UDColumn {

         New-UDCard -Content {"Washington"} -BackgroundColor blue -FontColor white

    

$kits |Where-Object {$_.State -eq 'WA'} |ForEach-Object {

$Tbl=$TblStyle

#tr:nth-child(odd) { background-color:#d3d3d3;}

#tr:nth-child(even) { background-color:white;}

$Tbl=$Tbl+"<table> <tr><th>"+ $_.KitName + "</th></tr>"

$_.Assets|ForEach-Object {

$Thref = "https://mydomain.ezofficeinventory.com/assets/"+$_.AssetID

$Ttitle = $_.Description

$Tbl=$Tbl+ '<tr bgcolor="'+$myBGColor[$_.State]+'"><td> <a href="'+$Thref+'" title="'+$Ttitle+'" target="_blank">' + $_.Name + '</td></tr>' }

$Tbl=$Tbl+ "</table>"

New-UDHtml -Markup $Tbl

}

} ### - End UDColumn

New-UDColumn {

         New-UDCard -Content {"Utah"} -BackgroundColor blue -FontColor white

    

$kits |Where-Object {$_.State -eq 'UT'} |ForEach-Object {

$Tbl=$TblStyle

#tr:nth-child(odd) { background-color:#d3d3d3;}

#tr:nth-child(even) { background-color:white;}

$Tbl=$Tbl+"<table> <tr><th>"+ $_.KitName + "</th></tr>"

$_.Assets|ForEach-Object {

$Thref = "https://mydomain.ezofficeinventory.com/assets/"+$_.AssetID

$Ttitle = $_.Description

$Tbl=$Tbl+ '<tr bgcolor="'+$myBGColor[$_.State]+'"><td> <a href="'+$Thref+'" title="'+$Ttitle+'" target="_blank">' + $_.Name + '</td></tr>' }

$Tbl=$Tbl+ "</table>"

New-UDHtml -Markup $Tbl

}

} ### - End UDColumn

########## - End UDRow

}

}

Counting Words with PowerShell

Building on the methods of Arthur Attwell's, Jose Barreto's and Tim Smith's posts. I expanded the word-freq.ps1 script with parameters, interactive mode, and significant performance improvements.

The script uses the Alise in Wonderland as the default text file with 3,736 lines and 28,601 words. When scaling up to larger text files the processing time was noticeable.

The Alise default file must be download and placed the same directory as the script.
http://www.gutenberg.org/files/11/11.txt

Thanks to Tim Smith's post there was over 2000% increase in the performance when using a different hash table method.
https://www.mssqltips.com/sqlservertip/3359/powershell-and-text-mining-part-i-word-counts-positions-and-libraries/

This script can also be found on 

GitHub: https://gist.github.com/Trifused/394752dbdffc616a17785a08b4cb963b

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180

# PowerShell: Counting words in a text file # Returns a list of the most-used, longest words in a text file. # ###### # # Post from From: https://gist.github.com/arthurattwell/f6552158f17db18ad48d286146f533c7 # Modified by Lawrence Billinghurst # Modification Data: April 2019 # and # Adapted slightly from # https://blogs.technet.microsoft.com/josebda/2015/03/21/powershell-examples-counting-words-in-a-text-file/ # Modified for the http:\\2019.report ###### # From: https://gist.github.com/arthurattwell/f6552158f17db18ad48d286146f533c7 ###### # Used color script from https://copdips.com/2018/05/grep-like-powershell-colorful-select-string.html # and https://github.com/copdips/PSScripts/blob/master/Text/Select-ColorString.ps1 ###### # Perfomance Bost # https://www.mssqltips.com/sqlservertip/3359/powershell-and-text-mining-part-i-word-counts-positions-and-libraries/ ###### ## Uses the text from Alice in Wonderland # from http://www.gutenberg.org/ebooks/11.txt.utf-8 param ( [Parameter(Mandatory=$False)] [string]$FileName= '.\Alice''sAdventureInWonderLand.txt' ,[Parameter(Mandatory=$False)] [string]$Search ,[Parameter(Mandatory=$False)] [string]$SortOrder ,[Parameter(Mandatory=$False)] [Alias("R")] [switch]$DisplayResults ,[Parameter(Mandatory=$False)] [Alias("I")] [switch]$Interactive ,[Parameter(Mandatory=$False)] [Alias("N")] [switch]$NoProgress ,[Parameter(Mandatory=$False)] [Alias("D")] [switch]$DontShow ,[Parameter(Mandatory=$False)] [Alias("E")] [switch]$ExportCSV ,[Parameter(Mandatory=$False)] [switch]$HashSwitch ) #Stopwatch Start $sw = [Diagnostics.Stopwatch]::StartNew() #Define some Values $NumberFound = 0 $WordCount = 0 $Longest = "" $Dictionary = @{} $LineCount = 0 $dashline="--------------------------------" if ((Test-Path -path $FileName)-eq $false) { $xMenuChoiceA = "0" while (($xMenuChoiceA -ne "1") -and ((Test-Path -path $FileName)-eq $False)){ Write-host $dashline [string]$xMenuChoiceA = read-host "Enter a file name or 1 to exit" if ( $xMenuChoiceA -eq "1"){ exit } else {$FileName=$xMenuChoiceA} } } #Define Funciton print-search results function print-search{ if (($SearchWord -ne "") -and (-not $DontShow)) { $NumberFound = (get-content $FileName| select-string -pattern $SearchWord).length Write-host $dashline if ($YesColors -eq $True) { Write-output "The word $SearchWord was found $NumberFound times." |Select-ColorString $SearchWord Write-host $dashline Select-String -Pattern $SearchWord $FileName |Select-ColorString $SearchWord} else { Write-Host "The word $SearchWord was found $NumberFound times." Write-host $dashline Select-String -Pattern $SearchWord $FileName } } } #Try to load select-colorstring function file $FunctionFile=".\Select-ColorString.ps1" if (Test-Path -path $FunctionFile) {. $FunctionFile $YesColors=$True} $SearchWord = $Search.ToUpper() $FileContents = Get-Content $FileName $TotalLines = $FileContents.Count if (-not $DontShow) { Write-Host "Reading file $FileName..." Write-host $dashline Write-Host "$TotalLines lines read from the file." Write-host $dashline} $FileContents | foreach { $Line = $_ $LineCount++ if (-not $NoProgress) { Write-Progress -Activity "Indexing Line ($LineCount of $TotalLines)..." -PercentComplete ($LineCount*100/$TotalLines) } $Line.Split(" .,:;?!/()[]{}-```"") | foreach { $Word = $_.ToUpper() If ($Word[0] -ge 'A' -and $Word[0] -le "Z") { $WordCount++ If ($Word.Contains($SearchWord)) { $Found++ } If ($Dictionary.ContainsKey($Word)) { if ($HashSwitch){ $Dictionary.$Word++ # Slow Method } else { $cnt = $Dictionary[$Word] + 1 $Dictionary.Remove($Word) $Dictionary.Add($Word, $cnt) } } else { $Dictionary.Add($Word, 1) } } } } if (-not $NoProgress) { Write-Progress -Activity "Indexing words..." -Completed } # Filter Word List to remove any single values and length greter than 2, then sort by Word name $WordCountList=$($Dictionary.GetEnumerator()| ? {($_.Value -gt 1) -AND ($_.Name.Length -gt 2)} | Sort Name ) $DictWords = $WordCountList.Count #$OutList = ($WordCountList | Select Name,Value -First 2) if (-not $DontShow) { Write-Host "$WordCount total words in the text" Write-Host "$DictWords distinct words in the text" } #Call the print resule function print-search #Stopwatch Stop $sw.Stop() switch ($SortOrder) { "1" {$WordCountList=$WordCountList|Sort Name ; break} "2" {$WordCountList=$WordCountList|Sort Name -Descending ; break} "3" {$WordCountList=$WordCountList|Sort Value ; break} "4" {$WordCountList=$WordCountList|Sort Value -Descending ; break} default {$WordCountList=$WordCountList|Sort Name ; break} } if ($DisplayResults) { #Show Results when R Switch is activeated $WordCountList|Select -First 5 |ft } if ($ExportCSV) { #Export file when E Switch is activeated $WordCountFileName=(split-path -path $FileName) +"\"+ ((gci $FileName).BaseName) + "-wordcount.csv" $WordCountList|select name,value|Export-Csv $WordCountFileName -NoTypeInformation } if ($Interactive){ $xMenuChoiceA = "0" while ( $xMenuChoiceA -ne "1"){ Write-host $dashline [string]$xMenuChoiceA = read-host "Enter word to search or 1 to exit" if ( $xMenuChoiceA -ne "1"){ Write-host $dashline $SearchWord = $xMenuChoiceA #Call the print resule function print-search } } }else{ $LogFileName=(split-path -path $MyInvocation.MyCommand.Name) +".\"+ ((gci $MyInvocation.MyCommand.Name).BaseName) + ".log.txt" #Write timing to Log file, skip if Interactive $LogEntery= $(Get-Date -Format 'MM/dd/yyyy,hh:mm tt')+","+$HashSwitch+","+$sw.Elapsed.TotalSeconds+","+$TotalLines+","+$WordCount+","+$DictWords+","+$FileName #Write-Host "Writing Log: "$LogEntery Add-Content $LogFileName $LogEntery }

Search directory and multiple file contents with Powershell

This script will search directory and file contents with Powershell




$HowManyDays = 7
$FileAge = (Get-Date).AddDays(-$HowManyDays)
$FindThis = "test"
$WhatFiles = "*.log"
$SearchWhere = ".\"

$MsgOut = 'Searching for "{0}" in {1} (files) starting in {2} for the past {3} days' -f $FindThis, $WhatFiles, $SearchWhere, $HowManyDays

#-----------------------------------------------------------[Execution]------------------------------------------------------------



Write-Host $MsgOut #  '+$WhatFiles +' starting in '+$SarchWhere
$fileList = Get-ChildItem -Path $SearchWhere -Recurse -Force -ErrorAction SilentlyContinue -Include $WhatFiles |Where-Object {$_.LastWriteTime -gt $FileAge}

#  This for each loop code "% {$i++;"$($i-1) `t $_"}" adds the line numbers to the output. Ref: https://superuser.com/questions/1182291/how-do-i-get-line-numbers-with-powershell/1272052#1272052

ForEach ($file in $filelist) { $i=1
 "Searching File ...:: "+$file.FullName
                                Get-Content $file.FullName -Force -ErrorAction SilentlyContinue | % {$i++;"$($i-1) `t $_"}| Select-String -pattern $FindThis}

Angular Logic

Anglar JS


Check if null

  app.controller('myController', function(){
    this.current = 0;
    this.setCurrent = function(newValue){
      this.current = newValue || 0;    < - this checks for null
    };

Useful Docer Commands

Delete all old containers

1. List them

sudo docker ps -a


2. remove all exited

sudo docker rm $(sudo docker ps -aq -f status=exited)


3. remove all created

sudo docker rm $(sudo docker ps -aq -f status=created)

Docker and Node.JS

My First Node.JS sever in Docker

Docker is a way to quickly deploy code in Linux that allows a repeatable process for automation at scale.    Please visit the Docker web site for more information: https://www.docker.com/what-docker

At this time I was running Hyper-V on Windows 10 64 bit with Intel i7 processor and a newly upgraded 500GB SSD from Samsung.

 The Linux VM I created was Ubuntu server 14.04 LTS

Dockerizing a Node.js web app
https://nodejs.org/en/docs/guides/nodejs-docker-webapp/

 

 

 

 

GitHub The Basics

The Basics of Git using GitHub

1. Setup a GitHub account: https://github.com/join
2. Setup a new project repository: https://help.github.com/articles/create-a-repo/
3. Setup a local repository





Links:

How to push local changes to a remote git repository
http://stackoverflow.com/questions/7690108/how-to-push-local-changes-to-a-remote-git-repository-on-bitbucket