User since Unblock chat User blocked This user's wishlist is not public. View profile View wishlist Start conversation Invite to friends Invite to friends Accept invitation Accept invitation Pending invitation. Send an email, install new software, restart the computer, any activity that you can think of at your fingertips.Change Log in Game Library completed Added by alburl alburl Sorry, data for given user is currently unavailable. I can hear you saying again – But if you already have that report in Lansweeper, why need for PowerShell? Well, based on that Lansweeper report, I can do any action I want in PowerShell. But if you have Lansweeper, it already has that information. But to get that you will have to scan every PC in your domain and that's not trivial because not all computers are online, at all times.
Think of a situation where the manager asks you what version of Microsoft Office is on all computers or as in the example above BIOS version. I can hear you asking – If Lansweeper is so great, why do you need to access it with PowerShell? Well, Lansweeper gathers a lot of data, lots of data that you usually have to spend time preparing in PowerShell thru different means, and that's not always the fastest way. Where tblBIOS.SMBIOSBIOSVersion Bios.biosMax And tblAssetCustom.State = 1 Inner Join tsysOS On tsysOS.OScode = tblAssets_1.OScode TblAssetCustom.Manufacturer = Bios.Manufacturer And TblAssetCustom_1.Model) As Bios On tblAssetCustom.Model = Bios.Model And TblAssetCustom_1.Model Not Like 'Virtual Machine' TblAssetCustom_1.Model Not Like 'VMware Virtual Platform' And Where tblAssetCustom_1.Model Not Like 'VirtualBox' And Inner Join tblBIOS As tblBIOS_1 On tblAssets.AssetID = tblBIOS_1.AssetID Inner Join tblAssetCustom As tblAssetCustom_1 On tblAssets.AssetID = Max(tblBIOS_1.SMBIOSBIOSVersion) As biosMax Inner Join (Select tblAssetCustom_1.Manufacturer, Inner Join tblAssetCustom On tblAssets_1.AssetID = tblAssetCustom.AssetID Inner Join tblBIOS On tblAssets_1.AssetID = tblBIOS.AssetID TblBIOS.SMBIOSBIOSVersion As CurrentBios,Ĭase When tblBIOS.SMBIOSBIOSVersion = Bios.biosMax Then 'black' Else 'red'
0 kommentar(er)
