Filip_V
Lansweeper Alumni
since ‎12-29-2014
‎07-11-2022

User Statistics

  • 7 Posts
  • 3 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Generate SQL queries to recreate your custom reports on another database. This code is designed for SQL Server and will not work on SQL Compact.SELECT 'INSERT INTO [tsysreports] ([Reportquery] ,[Reporttitle] ,[Sendmail] ,[Mailgrou...
SELECT TOP 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 AS icon, tblAssets.IPAddress, Serialnumber, DATEADD(DAY,7*SUBSTRING(Serialnumber,6,2)-7, DATEADD(YEAR,96+SUBSTRING(Serialnu...