I am already running that, thank you!
But I don't see anything that gives 1 user with multiple machines, by user.
Ah, I see what you're saying... except it isn't going to get you what you want, IMHO.Login name is far too likely to pick up all your help desk guys, not to mention SYSTEM or Administrator on servers. Not to mention causing you to delete records where the user legitimately has two systems.
If it's truly an out-dated duplicate record, it won't be getting updated any more.
I agree AND...
It will help me find users who have 2 machines (both desktops - naming convention) and one hasn't been started in 5 months.
Chances are, since I know the help desk guys, and if they worked on the machine 3 months ago and it hasn't been on since, they killed it -- which means I can delete it.
Is there a way to get a listing of multiple machines by the same user?
Thanks again for your responses,
Use the query I gave you. View as report, sort on the column you want.
Thanks again for the QUICK response!!
This query won't tell me machines that are in use.
I want to see a user with 2 machines: 1 that's reported within recently
and one that's old. This tells me, that the older machine was probably
replaced, but the Help Desk didn't delete it from LANDesk. THAT'S what
I'm trying to do. Manually make that determination.
Conversely, I could set my inventory to drop machines 90 days or older,
but because I am not sure that my inventory is correct, I choose not to
The query I've given you will do just that. I'm not sure where the problem is?
If you need to do the user method, then use the webconsole.
Set up a query that searches for devicename EXISTS but uses only the login name as the displayed column (this is a benefit of webconsole), then add a count and sort by that column.
What you should get is a list of users names with a number against them which is the count of the number of times they appear. For all of those that are there more than once you can click the name and it will give you a list of the machines that make up that count.
Unfortunately you can't customise the columns on the drill-down so you will then have to use the main console to search for that login name, use custom columns to show the date last scanned, and then take your decision of which machines to delete after that.
A bit convoluted, but probably the closest you can get without some nifty sql scripting.
Mark Star - MarXtar LANDesk Enhancements
Home of Power State Notifier & Wake-On-WAN for LANDesk
New Updated Power State Notifier Pro!