cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
A new Google Chrome vulnerability has been discovered. Take a look at the details on our blog post.

You can find the deployment package for Chrome here.

The report below gives an overview of all active Windows, Linux and Mac assets that have Google Chrome installed. It's color coded so you can easily identified assets that do not have Google Chrome version 72.0.3626.121.

To run this report in Lansweeper, you can follow the instructions here.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
Case
When tblSoftware.softwareVersion = '72.0.3626.121' Then 'Up to date'
Else 'Out of date'
End As [Patch Status],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftware.Lastchanged,
Case
When tblSoftware.softwareVersion <> '72.0.3626.121' Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like '%Google Chrome%' And tblState.Statename =
'Active'
Union
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblMacOSInfo.SystemVersion As OS,
tblAssets.SP,
Case
When tblMacApplications.Version = '72.0.3626.121' Then 'Up to date'
Else 'Out of date'
End As [Patch Status],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblMacApplications.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblMacApplications.LastChanged,
Case
When tblMacApplications.Version <> '72.0.3626.121' Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblMacApplications On
tblAssets.AssetID = tblMacApplications.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblMacApplications.softid
Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
Where tblSoftwareUni.softwareName Like '%Google Chrome%' And tblState.Statename =
'Active'
Union
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease As OS,
tblAssets.SP,
Case
When tblLinuxSoftware.Version = '72.0.3626.121-1' Then 'Up to date'
Else 'Out of date'
End As [Patch Status],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblLinuxSoftware.LastChanged,
Case
When tblLinuxSoftware.Version <> '72.0.3626.121-1' Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblSoftwareUni.softwareName Like '%google-chrome%' And tblState.Statename =
'Active'
Order By Domain,
AssetName,
Software
23 Comments
Thorsten_Pfeife
Engaged Sweeper
Hi Esben,

thanks for the nice and helpful report.
I already let it run but something is weird. Version 72.03626.81 which is < then 72.03626.121 is colored in green and I expected red.
An idea why?

Cheers
Thorsten
doone128
Engaged Sweeper III
Thanks. This is great.

However, could you please add - as per the Windows Updates reports - an 'up to date' and 'out of date' column so that we can easily filter the results?

Many thanks!
Leslie_Strooban
Engaged Sweeper III
Thorre wrote:
Hi Esben,

thanks for the nice and helpful report.
I already let it run but something is weird. Version 72.03626.81 which is < then 72.03626.121 is colored in green and I expected red.
An idea why?

Cheers
Thorsten


This is just a guess, but perhaps this is more an alphabetical sorting than a numerical one. Really not sure though.
robisonr
Engaged Sweeper
Thorre wrote:
Hi Esben,

thanks for the nice and helpful report.
I already let it run but something is weird. Version 72.03626.81 which is < then 72.03626.121 is colored in green and I expected red.
An idea why?

Cheers
Thorsten


There is something weird with the way > and < works with Chrome version numbers. I've had success with switching to casting the version numbers and then comparing

Replace:
When tblSoftware.softwareVersion < '72.0.3626.121'

With:
When Cast('/' + Replace(tblSoftware.softwareVersion, '.', '/') + '/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid)
Esben_D
Lansweeper Employee
Lansweeper Employee
Thorre wrote:
Hi Esben,

thanks for the nice and helpful report.
I already let it run but something is weird. Version 72.03626.81 which is < then 72.03626.121 is colored in green and I expected red.
An idea why?

Cheers
Thorsten


Yeah, its the unfortunate string comparison in SQL I'll change it.

The new version will only display Chrome versions with 72.03626.121 as green. But If a newer version of Chrome is released, you'll have to update the report with the new, latest version number.

doone128 wrote:
Thanks. This is great.

However, could you please add - as per the Windows Updates reports - an 'up to date' and 'out of date' column so that we can easily filter the results?

Many thanks!

Done
jess818
Engaged Sweeper
SQL is using string comparison. You can use CAST to explicitly compare the version numerically. Here is my revision of the query:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftware.Lastchanged,
Case
When Cast(Replace(tblSoftware.softwareVersion, '.', '') As BIGINT) <
7203626121 Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like '%Google Chrome%' And
tblState.Statename = 'Active'
Union
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblMacOSInfo.SystemVersion As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblMacApplications.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblMacApplications.LastChanged,
Case
When Cast(Replace(tblMacApplications.Version, '.', '') As BIGINT) <
7203626121 Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblMacApplications On
tblAssets.AssetID = tblMacApplications.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblMacApplications.softid
Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
Where tblSoftwareUni.softwareName Like '%Google Chrome%' And
tblState.Statename = 'Active'
Union
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblLinuxSoftware.LastChanged,
Case
When Cast(Replace(tblLinuxSoftware.Version, '.', '') As BIGINT) < 7203626121
Then '#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblSoftwareUni.softwareName Like '%google-chrome%' And
tblState.Statename = 'Active'
Order By Domain,
AssetName,
Software
robisonr
Engaged Sweeper
Jay818 wrote:
SQL is using string comparison. You can use CAST to explicitly compare the version numerically. Here is my revision of the query


This works for this instance but if you're comparing version numbers like 72.0.3626.121 and 72.0.3627.90 if will fail due to the second number being less digits overall even though it's a newer version.

We solved this with casting and heirarchyID:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
Case
When Cast('/' + Replace(tblSoftware.softwareVersion, '.', '/') +
'/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid) Then
'Up to date'
Else 'Out of date'
End As [Patch Status],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftware.Lastchanged,
Case
When Cast('/' + Replace(tblSoftware.softwareVersion, '.', '/') +
'/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid) Then
'#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like '%Google Chrome%' And
tblState.Statename = 'Active'
Union
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblMacOSInfo.SystemVersion As OS,
tblAssets.SP,
Case
When Cast('/' + Replace(tblMacApplications.Version, '.', '/') +
'/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid) Then
'Up to date'
Else 'Out of date'
End As [Patch Status],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblMacApplications.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblMacApplications.LastChanged,
Case
When Cast('/' + Replace(tblMacApplications.Version, '.', '/') +
'/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid) Then
'#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblMacApplications On
tblAssets.AssetID = tblMacApplications.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblMacApplications.softid
Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
Where tblSoftwareUni.softwareName Like '%Google Chrome%' And
tblState.Statename = 'Active'
Union
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease As OS,
tblAssets.SP,
Case
When Cast('/' + Replace(tblLinuxSoftware.Version, '.', '/') +
'/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid) Then
'Up to date'
Else 'Out of date'
End As [Patch Status],
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblLinuxSoftware.LastChanged,
Case
When Cast('/' + Replace(tblLinuxSoftware.Version, '.', '/') +
'/' As hierarchyid) < Cast('/72/0/3626/121/' As hierarchyid) Then
'#ffadad'
Else '#d4f4be'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblSoftwareUni.softwareName Like '%google-chrome%' And
tblState.Statename = 'Active'
Order By Domain,
AssetName,
Software
Esben_D
Lansweeper Employee
Lansweeper Employee
robisonr wrote:


This works for this instance but if you're comparing version numbers like 72.0.3626.121 and 72.0.3627.90 if will fail due to the second number being less digits overall even though it's a newer version.

We solved this with casting and heirarchyID


I'm not familiar with heirarchyid, but reading up on it a bit it seems that it can indeed be a solution. Unfortunately, it doesn't work with an SQL Compact database. For SQL server users, this will indeed be a more future proof report.

FYI I did get an error with your version in SSMS:

Msg 6522, Level 16, State 2, Line 1
A .NET Framework error occurred during execution of user-defined routine or aggregate "hierarchyid":
Microsoft.SqlServer.Types.HierarchyIdException: 24001: SqlHierarchyId.Parse failed because the input string '/72/0/3626/121-1/' is not a valid string representation of a SqlHierarchyId node.
Microsoft.SqlServer.Types.HierarchyIdException:
at Microsoft.SqlServer.Types.OrdPath.InitFromString(String chDottedString)
at Microsoft.SqlServer.Types.SqlHierarchyId.Parse(SqlString input)
.
joe_user
Engaged Sweeper III
Excited to see mention of an approach that might let us address software version issues.

The heirarchyid version of the report returns a red-on-red warning below the graphic portion of the Lanasweeper report editor but above the tabular section; the text of this warning was almost entirely obscured by the tabular section of the screen, but I was able to triple-click into the space to select the text to copy/paste it below.

Our Lansweeper data is stored in Microsoft SQL Server 2008 R2 (64-bit) and Microsoft .NET Framework 4.5.2. Could our issue could have to do with SQL / .NET version.?

From what I read here, our SQL version supports SQLHierarchyId.

Maybe we need to install a feature pack for SQL server? I've read "The SQL Server System CLR Types package contains the components implementing the new geometry, geography, and hierarchyid types in SQL Server 2008."

Maybe .NET needs to be at 4.6 or higher?

Here's the warning message:
A .NET Framework error occurred during execution of user-defined routine or aggregate "hierarchyid": Microsoft.SqlServer.Types.HierarchyIdException: 24001: SqlHierarchyId.Parse failed because the input string '/69/0/3497/92-1/' is not a valid string representation of a SqlHierarchyId node. Microsoft.SqlServer.Types.HierarchyIdException: at Microsoft.SqlServer.Types.ex_raise(Int32 major, Int32 minor, Int32 sev, Int32 state, Object param1, Object param2, Object param3) at Microsoft.SqlServer.Types.OrdPath.InitFromString(String chDottedString) at Microsoft.SqlServer.Types.SqlHierarchyId.Parse(SqlString input) .
AZHockeyNut
Champion Sweeper III
joe_user wrote:
Excited to see mention of an approach that might let us address software version issues.

The heirarchyid version of the report returns a red-on-red warning below the graphic portion of the Lanasweeper report editor but above the tabular section; the text of this warning was almost entirely obscured by the tabular section of the screen, but I was able to triple-click into the space to select the text to copy/paste it below.

Our Lansweeper data is stored in Microsoft SQL Server 2008 R2 (64-bit) and Microsoft .NET Framework 4.5.2. Could our issue could have to do with SQL / .NET version.?

From what I read here, our SQL version supports SQLHierarchyId.

Maybe we need to install a feature pack for SQL server? I've read "The SQL Server System CLR Types package contains the components implementing the new geometry, geography, and hierarchyid types in SQL Server 2008."

Maybe .NET needs to be at 4.6 or higher?

Here's the warning message:
A .NET Framework error occurred during execution of user-defined routine or aggregate "hierarchyid": Microsoft.SqlServer.Types.HierarchyIdException: 24001: SqlHierarchyId.Parse failed because the input string '/69/0/3497/92-1/' is not a valid string representation of a SqlHierarchyId node. Microsoft.SqlServer.Types.HierarchyIdException: at Microsoft.SqlServer.Types.ex_raise(Int32 major, Int32 minor, Int32 sev, Int32 state, Object param1, Object param2, Object param3) at Microsoft.SqlServer.Types.OrdPath.InitFromString(String chDottedString) at Microsoft.SqlServer.Types.SqlHierarchyId.Parse(SqlString input) .


@robinsonr Nice work! Worked perfect for me on SQL server thanks!!
marck1024
Engaged Sweeper III
Esben.D wrote:
...heirarchyid...doesn't work with an SQL Compact database...

Do yourself a favor and consider moving to SQL Server Express. I got a nice performance boost when I did that. Express is running on the same server as Lansweeper. So, no additional hardware in the mix.

lbd
Engaged Sweeper
Hi
I'm getting this error when i try the HiearchyID version:

Error: A .NET Framework error occurred during execution of user-defined routine or aggregate "hierarchyid": Microsoft.SqlServer.Types.HierarchyIdException: 24001: SqlHierarchyId.Parse failed because the input string '//' is not a valid string representation of a SqlHierarchyId node. Microsoft.SqlServer.Types.HierarchyIdException: at Microsoft.SqlServer.Types.SqlHierarchyId.Parse(SqlString input) .

I suspect, that i have a version with (..), any suggestions to get aroud this?
lbd
Engaged Sweeper
Managed to fix my problem, by implementing af replace that turned // into /
Esben_D
Lansweeper Employee
Lansweeper Employee
marck1024 wrote:
Esben.D wrote:
...heirarchyid...doesn't work with an SQL Compact database...

Do yourself a favor and consider moving to SQL Server Express. I got a nice performance boost when I did that. Express is running on the same server as Lansweeper. So, no additional hardware in the mix.



Believe me I am, and I would also recommend it to anyone. But I know many people (especially with smaller installations) use SQL Compact. So I can't publish reports that only work on SQL Server if there is a possibility to make it work on SQL Compact.
joe_user
Engaged Sweeper III
Lasse Dollerup wrote:
Managed to fix my problem, by implementing af replace that turned // into /


Lasse Dollerup, could you please explain what is meant by your statement below?

"implementing af replace that turned // into /"

Seems like we encountered the same issue, so I'm hoping your fix works for me.

Thanks!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now