It would be nice to know when an asset get physically moved from one location/subnet to another one. Yes, this has happened to us, and by the time we caught it, no one knew who did it. I could not find a table that stored a previous IP Location or I...
I was trying to create a dynamic asset group for all Mozilla Firefox version, and wanted to use some type of wild card instead of listing each out. What I am trying to accomplish is to list all computer with Firefox that do not have the most current ...
Hello Forum!I can't seem to get this Query to work as elegantly as I would like; can someone please assist with a report for google chromeversion of google chromeIP location?I appreciate it thanks
I have created a report that will show me computers that are on for over 24 hours. The report shows me everything that I need with the exception that computers not scanned that morning show up. I have setup a company wide scan to happen at 2a every...
I need a list of all the PCs in an IP range. Looking to see if they have Microsoft Office, but I also want to list the rest of the PCs without Office as well. Here is what the report looked like before v5. I get an error on the upgraded reports. T...
Hi,i hope you can help me. We need to upgrade all older Versions to Microsoft Office 2010.So, i need a report wich show me a list of all Assets they're have Microsoft Office Products older than Microsoft Office 2010 installed. (14.0)This is my code n...
I was messing around with the asset out of warranty report and screwed something up. Now I keep getting the error "error while getting report Data conversion failed. [ OLE DB status value (if known) = 2 ]" Here is my code Select Top 1000000 tblAssetC...