Hi there,

I'm trying to run a run report to find which users have a specific model laptop in  specific. In more detail, the report should have all the users that use a Lattitude e6420 and e6430 in our Boston Laptops Smart Label. Is that possible?
2 Comments   [ + ] Show Comments

Comments

  • Yes, The built in wizard can do that for you easily. The user would be the issue since the Inventory captures last logged in. If you haven' t used the Assets module to hard code in an owner, the data won't be 100%.
  • All our computers are in the Asset module. What is the procedure on how to run the report? I've tried, but I do not know the fields and areas to use.
    • Have you created a custom field that you have assigned an owner to that device? Computers will automatically go into Assets when you install an agent but then you have to add the extra field that says , this is the owner and map it to the User table in the drop down.

      You could start with this. I used the wizard to get the user full name and user name along with the models as a regex

      SELECT USER_FULLNAME, MACHINE.USER_NAME, CS_MODEL FROM MACHINE WHERE ((CS_MODEL rlike 'e6420|e6430') AND (CHASSIS_TYPE like '%laptop%') AND (( exists (select 1 from LABEL, MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND MACHINE_LABEL_JT.LABEL_ID = LABEL.ID AND LABEL.TYPE <> 'hidden' and LABEL.NAME like '%Boston%')) )) ORDER BY CS_MODEL
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity