
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2009 09:54 PM
Hi,
Need assistance building a report and exporting it to excel.. Need to report specific software for licensing. For example nned ot find number of installations for Visio, project, etc. Need to include the workstation name, software version and user name if possible. Have made several attempts in Report builder (have the latest 3.5.2.6) but the reports come up blank. I watched the video and have attepted to use the concepts but have not had success. I don't use access or sql much so am a little lost.
The sql comes up
Select Top 100 Percent tblSoftware.softwareName, tblSoftware.SoftwarePublisher,
tblComputers.Computername, tblSoftware.softwareVersion
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'Visio'
Thanks for your help
Paul
Need assistance building a report and exporting it to excel.. Need to report specific software for licensing. For example nned ot find number of installations for Visio, project, etc. Need to include the workstation name, software version and user name if possible. Have made several attempts in Report builder (have the latest 3.5.2.6) but the reports come up blank. I watched the video and have attepted to use the concepts but have not had success. I don't use access or sql much so am a little lost.
The sql comes up
Select Top 100 Percent tblSoftware.softwareName, tblSoftware.SoftwarePublisher,
tblComputers.Computername, tblSoftware.softwareVersion
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'Visio'
Thanks for your help
Paul
Labels:
- Labels:
-
Archive
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-31-2009 12:54 PM
I think this would be a good place to start : http://msdn.microsoft.com/en-us/library/ms190659%28SQL.90%29.aspx

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2009 08:02 PM
Thanks again,, Could not see in there unti I rebooted the machine. Then the reports I created were visible. Also fyi, was loosing the "results" tab in report builder. Back after the reboot.
Do you have a list of "expressions" and syntax (or where to locate that info) to use n the were statements.. Figured out the "like" and "Not Like" plus using a "and" . Not sure if there are any more.
Thanks for all your help
Do you have a list of "expressions" and syntax (or where to locate that info) to use n the were statements.. Figured out the "like" and "Not Like" plus using a "and" . Not sure if there are any more.
Thanks for all your help

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2009 11:37 AM
In the configuration utility you can change which reports are seen in the dashboards (dropdown list)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2009 02:35 AM
Ok,
great, that worked. Thanks
Now I need/want to be able to access these reports from within LanSweeper itself. So these reports don't seem to show up anywhere else other than report builder. Is there a method for them to show up Where they could be used on the LanSweeper Web interface?? It would be nice for others to be able to run them or for me to put them on the dashboard etc.
Paul
great, that worked. Thanks
Now I need/want to be able to access these reports from within LanSweeper itself. So these reports don't seem to show up anywhere else other than report builder. Is there a method for them to show up Where they could be used on the LanSweeper Web interface?? It would be nice for others to be able to run them or for me to put them on the dashboard etc.
Paul

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2009 11:06 PM
Is the software name 'visio'?
Most likely you will need to use wildcards. (%)
try:
Where tblSoftware.softwareName Like 'Visio%'
Most likely you will need to use wildcards. (%)
try:
Where tblSoftware.softwareName Like 'Visio%'
