Noobmode
Engaged Sweeper III
since ‎02-12-2019
‎07-11-2022

User Statistics

  • 16 Posts
  • 0 Solutions
  • 5 Kudos given
  • 1 Kudos received

User Activity

"The operation failed: The relationship could not be changed because one or more of the foreign-key properties is non-nullable. When a change is made to a relationship, the related foreign-key property is set to a null value. If the foreign-key does ...
/** Select required fields from tables **/Select Top 1000000 t1.AssetID, t1.AssetName, t2.Username, t2.Domainname, t2.Groupname, t3.Domainrole,/** Sets naming convention based on domain role **/ Case t3.Domainrole When 1 Then 'WORKSTATION' ...
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lastseen, tblAssets.Lasttried, tblRegistry.Regkey, tblRegistry....
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tblAssets.Lastseen, tblAssets.Lasttried, tblRegistry.Regkey, tblRegistry....
Microsoft SQL Server 2014 SP3 CU1Lansweeper 7.0.151.4SQL lives on a different server than Lansweeper. All permissions appear to be correct on the database and the user being utilized to scan has local administrator permissions on the endpoints.All sy...
Kudos from