Hi,I've Frankensteined a report from a post here and there and I'm getting close to where I want it to be. Here is what I have so far:Select Distinct Top 1000000 tsysOS.Image As Icon, tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAss...
Thanks again RC62N! That did it. I appreciate the help and the suggestions for keeping it clean. I'm not a fan of messy confusing scripts when it comes to PowerShell so the SQL query is killing me since I don't know it as well.
RC62N wrote:Refer to this thread. You should be able to use the information there to set up a CASE statement to assign the colours you want.Thanks RC62N. I was able to figure it out and make some additional changes as well after taking the weekend a...
