Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Software Report
BenKnox
#1 Posted : Tuesday, April 27, 2010 7:36:11 AM

Rank: Premium user

Groups: Premium Users
Posts: 17
Location: Australia
Hello,

I was just wondering if there was an easy way to do this;

When i search for a software in the web console, it lists the: computer name, description, domain, software, version and date. I can then export this information to a spreadsheet.
However i wanted to add the field 'last user' to the spreadsheet, so that it also exports the user name of the person using the computer. Is there any way of customizing this? At the moment i have to individually click on each computer to see which user is using it.

Thanks,
Ben
Lansweeper
#2 Posted : Tuesday, April 27, 2010 8:33:16 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
You can customize stored procedure "Web40FindsoftwareName" (not supported)
Note that in a future update your changes might be overwritten.
BenKnox
#3 Posted : Friday, May 14, 2010 4:18:27 AM

Rank: Premium user

Groups: Premium Users
Posts: 17
Location: Australia
Lansweeper wrote:
You can customize stored procedure "Web40FindsoftwareName" (not supported)
Note that in a future update your changes might be overwritten.


When i right click on this procedure and click 'modify'
It opens it as a NEW query rather than letting me modify the existing one.
Lansweeper
#4 Posted : Friday, May 14, 2010 10:51:30 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
You need to have sql server management studio to do this (note that we don't support this)
taeratrin
#5 Posted : Friday, May 14, 2010 2:21:46 PM

Rank: Premium user

Groups: Premium Users
Posts: 214
When modifying a stored procedure is SQL Management Studio, it scripts an ALTER statement to a new query window instead of letting you edit it directly. Just make the changes you'd like to see in the ALTER statement and execute the query.
BenKnox
#6 Posted : Tuesday, May 18, 2010 5:06:50 AM

Rank: Premium user

Groups: Premium Users
Posts: 17
Location: Australia
taeratrin wrote:
When modifying a stored procedure is SQL Management Studio, it scripts an ALTER statement to a new query window instead of letting you edit it directly. Just make the changes you'd like to see in the ALTER statement and execute the query.


thanks heeps taeratrin! Very helpful
BenKnox
#7 Posted : Tuesday, May 18, 2010 9:09:56 AM

Rank: Premium user

Groups: Premium Users
Posts: 17
Location: Australia
FYI all i needed to do was add
" , Username" to the end of the 'as select distinct' part of the web40findsoftwarename script.
Pretty simple :)
Now i'm just working on trying to get it to display firstname/last name, as that is much more useful than the username, any advice would be appreciated! (I know it is not supported)
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba