Lansweeper 3.5.x Report "Software Cost Tracker" will not work in v4

[AdmJLovejoy]

Any idea what it will take to get this to work in v4?

Select Top 100 Percent dbo.tblLicenses.softwareName,
dbo.tblLicenses.softwareVersion, dbo.web30repUsedSoftware.SoftwarePublisher As
Publisher, dbo.web30repUsedSoftware.[number in use],
dbo.tblLicenses.Nrlicenses, dbo.tblLicenses.Priceperlicense, Case
When (dbo.web30repUsedSoftware.[number in use] > dbo.tblLicenses.Nrlicenses)
Then (dbo.web30repUsedSoftware.[number in use] - dbo.tblLicenses.Nrlicenses)
Else Null End As Missing, Case
When (dbo.web30repUsedSoftware.[number in use] > dbo.tblLicenses.Nrlicenses)
Then (dbo.web30repUsedSoftware.[number in use] - dbo.tblLicenses.Nrlicenses)
* dbo.tblLicenses.Priceperlicense Else Null End As Price
From dbo.web30repUsedSoftware Inner Join
dbo.tblLicenses On dbo.web30repUsedSoftware.softwareName =
dbo.tblLicenses.softwareName And dbo.web30repUsedSoftware.softwareVersion =
dbo.tblLicenses.softwareVersion
Order By Case
When (dbo.web30repUsedSoftware.[number in use] > dbo.tblLicenses.Nrlicenses)
Then (dbo.web30repUsedSoftware.[number in use] - dbo.tblLicenses.Nrlicenses)
* dbo.tblLicenses.Priceperlicense Else Null
End Desc, dbo.tblLicenses.softwareName, dbo.tblLicenses.softwareVersion

[AdmJLovejoy]

That did it, problem solved.

[Hemoco]

Now there are 2 tables:
tbllicenses
tblsublicenses

The 2e table contains the information that you need.

[AdmJLovejoy]

Looks like column dbo.tblLicenses.softwareVersion has been removed in v4



Select Top 100 Percent dbo.tblLicenses.softwareName,
dbo.tblLicenses.softwareVersion, dbo.web40repUsedSoftware.SoftwarePublisher As
Publisher, dbo.web40repUsedSoftware.[number in use],
dbo.tblLicenses.Nrlicenses, dbo.tblLicenses.Priceperlicense, Case
When (dbo.web40repUsedSoftware.[number in use] > dbo.tblLicenses.Nrlicenses)
Then (dbo.web40repUsedSoftware.[number in use] - dbo.tblLicenses.Nrlicenses)
Else Null End As Missing, Case
When (dbo.web40repUsedSoftware.[number in use] > dbo.tblLicenses.Nrlicenses)
Then (dbo.web40repUsedSoftware.[number in use] - dbo.tblLicenses.Nrlicenses)
* dbo.tblLicenses.Priceperlicense Else Null End As Price
From dbo.web40repUsedSoftware Inner Join
dbo.tblLicenses On dbo.web40repUsedSoftware.softwareName =
dbo.tblLicenses.softwareName And dbo.web40repUsedSoftware.softwareVersion =
dbo.tblLicenses.softwareVersion
Order By Case
When (dbo.web40repUsedSoftware.[number in use] > dbo.tblLicenses.Nrlicenses)
Then (dbo.web40repUsedSoftware.[number in use] - dbo.tblLicenses.Nrlicenses)
* dbo.tblLicenses.Priceperlicense Else Null
End Desc, dbo.tblLicenses.softwareName, dbo.tblLicenses.softwareVersion

[Hemoco]

Maybe the stored procedure "web40softwarelicenses" can help you, it's almost similar.