Kreg
Engaged Sweeper II
since ‎11-20-2012
‎07-11-2022

User Statistics

  • 26 Posts
  • 0 Solutions
  • 2 Kudos given
  • 1 Kudos received

User Activity

Hi there,Has anyone ever tried to change the status for many assets via SQL?We need to change the status for 800 devices.Based on the serial number listsCurrently there are several states (A/B/C...) I need my 800 serial numbers to be in the "D" state...
Hi there,I'm trying to make a report to sort all my PCs to show the lastest 3 users and logon time by computer.But actually I don't know how to limit to the last 3 users. Please, do you have an idea how to do that ?Actually here is my report (that sh...
Hi there,I'm trying to create some basic queries for the software compliance.The goal is to show on the dashboard my core applications non compliant to the version defined.Example, Acrobat Reader < 11.0.4So I've made I query like that, but the result...
Hi there,I need to create a very simple report to show all of my users for 2 mails domain, and without "prestataire, interimaire and stagiaire".Easy, yes my report works, but I don't know why I've some users duplication.I have only 3 columns with uni...
Hi there,i would like to know if it's possible to have a query to show :Computer for a specific asset group with the last connection time and the number of "usage" for the last 3 months.I have this query but I don't know why I've a lot of entry for e...
Kudos from
Kudos given to