Generating reports

[Jigesh]

Hi,

I am a premium user for lansweeper. I need to generate reports where in any software of hardware change in the systems in the domain should be notified to the administrator as a report. I have limited knowledge on generating reports. Can someone please guide me get started on it?

Thanks,
Jigesh

[Hemoco]

There is no way of knowing how microsoft will name their next update, they even change their naming convention sometimes, some automatic updates name "XML SP2" or something alike and some updates are written in non-english

[Jigesh]

Ok. The list of softwares in the newtwork domain also includes the list of all the softwares that came in built with the laptops in the organization and also the hot fixes. Is there any way of knowing only the softwares that were externally and did not come with the standard package in the laptop. The problem with hotfixes is that each time it is run it would generate a new one with a different ID which will end up in me having to manually add it to the approved software list each time. Can you help in getting around this problem?

[Hemoco]

There is a screen for this in the configuration console.

[Jigesh]

The query works fine now. I think earlier there was some problem with the indentation. Can i know how can I add software names to the approvedsoftware table. Thank you for being so helpful so far. I appreciate it.

Jigesh

[Hemoco]

Could you post a screenshot of this please.
You can see all tables/fields in the report builder.

[Jigesh]

Also, when i execute the report above I haev an error saying that there is incorrect syntax near 'AS'. Can you please help me come over it?

Thanks,
Jigesh

[Jigesh]

Ok. Thank you. How can I change the contents of any table in the database in lansweeper? How can I view the contents of a table?

[Hemoco]

Try this:

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblSoftware.softwareName AS Software, 
                      dbo.tblSoftware.softwareVersion AS Version, dbo.tblSoftware.Lastchanged
FROM         dbo.tblSoftware INNER JOIN
                      dbo.tblComputers ON dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername INNER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE     (NOT (dbo.tblSoftware.softwareName IN
                          (SELECT     software
                            FROM          tblapprovedsoftware)))
ORDER BY dbo.tblComputers.Computername

[Jigesh]

Thanks a lot.
One more question that I had about the reorts. How can we perhaps generate a report of all unauthorised software that is existent on the domain computers.
Any help would be greatly appreciated.