→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
yogeshtikhe
Engaged Sweeper
Hi All

we see first uninstall report last 30 or 60 days in lansweepers but i want some changes on report as below so anyone help me to send changes report scripts

Required uninstall report last 60 days

Asset domain |PC Computer Name |Software Name |Software Version| software Install date | software uninstall date | Assets Name |
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
Reply sent via email:
A general report that lists software changes that occurred in the last 60 days can be seen below. Keep in mind however that:
  • SQL displays each table record (e.g. software addition/removal) as a line, not a column. You cannot create separate columns for additions/removals.
  • From a Lansweeper point of view, there is no difference between a software update and an addition/removal. If a software is updated, you'll see a removal of the old software version and an addition of the new software version.

Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  • Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.Image As icon,
Case tblSoftwareHist.Action When '1' Then '+' When '2' Then '-' End As [+/-],
tblSoftwareUni.softwareName As Software,
tblSoftwareHist.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftwareHist.Installdate,
tblSoftwareHist.Lastchanged
From tblAssets
Inner Join tblSoftwareHist On tblAssets.AssetID = tblSoftwareHist.AssetID
Inner Join tblSoftwareUni On tblSoftwareHist.softid = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareHist.Lastchanged > GetDate() - 60 And tblAssetCustom.State = 1
Order By tblSoftwareHist.Lastchanged Desc

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
Reply sent via email:
A general report that lists software changes that occurred in the last 60 days can be seen below. Keep in mind however that:
  • SQL displays each table record (e.g. software addition/removal) as a line, not a column. You cannot create separate columns for additions/removals.
  • From a Lansweeper point of view, there is no difference between a software update and an addition/removal. If a software is updated, you'll see a removal of the old software version and an addition of the new software version.

Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  • Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.Image As icon,
Case tblSoftwareHist.Action When '1' Then '+' When '2' Then '-' End As [+/-],
tblSoftwareUni.softwareName As Software,
tblSoftwareHist.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftwareHist.Installdate,
tblSoftwareHist.Lastchanged
From tblAssets
Inner Join tblSoftwareHist On tblAssets.AssetID = tblSoftwareHist.AssetID
Inner Join tblSoftwareUni On tblSoftwareHist.softid = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareHist.Lastchanged > GetDate() - 60 And tblAssetCustom.State = 1
Order By tblSoftwareHist.Lastchanged Desc