SQL report to find current user Mapped network drives?
Does anyone have a SQL script to run on a report to get the current user mapped network drives from all PC's?
Answers (1)
I don't think that the inventory collects that information. It would also be complicated by the fact that the inventory runs as system, so I don't know that the network drives would show up. Add to that: if the last inventory ran when no user was logged in, there wouldn't be any drives to show.
I think to accomplish this you would first need to have a script that ran in the user context and put a list of network drives in a file. You would then pull the contents of that file into a custom inventory field that you could use in reporting.