Hi, AllI have been banging my head against the wall on this, if I remove the McAfee tblRegistry, I get the expected 36 assest, however, I only get 29 assets with the table in there.is there a way to have the report include the missing systems?I added...
Select Top 1000000 tsysOS.Image As icon, tblAssetCustom.AssetID, tblAssets.AssetName, tblAssets.Processor, tblAssets.Memory, tblBIOS.SMBIOSBIOSVersion, tsysOS.OSname As OS, tblAssets.SP As SP, tblAssetCustom.Warrantydate As [Warranty Expirati...
I am running the following report, however, I am missing computers, the built in Asset report detects it, I think the common denominator is no user logged onSelect Top 1000000 tsysOS.Image As icon, tblAssetCustom.AssetID, tblAssets.AssetName, tblA...
Hi all, I am a complete noob when is comes to SQL.I have a report set up to report failed log on event 4625, but I would like to parse information from the message:Information I would like to have:Account Name:Account Domain:Failure Reason:Workstatio...
Hendrik.VE wrote: Case When tblSoftware.softwareVersion < '5.7.5%' Then tblSoftware.softwareVersion Else ':)' End As 'McAfee'thanks Hendrik.VE building on that I am now hoping to expand to includeWhen tblSoftware.s...
does anyone know a way to make the software version show instead of 'Outdated'I have changed the 'Up to date' to ':)' as it makes the report more visibly pleasing to board members using McAfee agent as an example Left Join (Select Top 1000000 tbl...
I have removed a little and have better results, however; I am still missing a couple of computers, any ideas?Select Top (1000000) tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypeIcon10 As icon, Case When tblRegistrySB.Value Is ...
hirogen wrote:Can i use this to uninstall mcafee from our clients as we're moving to trendare you using corporate McAfee? i.e. the framework package? if so NO, if not Yes!use this script to uninstall corporate:"C:\Program Files (x86)\McAfee\Common ...