![]() ![]() 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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |