description field???

[jcorso11]

What is that a description of. My active directory environment uses the description field alot. That information is not in the web page description column in lansweeper and need it to be.

[Hemoco]

Could you try logging on with sql authentication (user lansweeperuser)

[jcorso11]

integrated. Domain admin

[Hemoco]

With which user are you connecting to the database?

[jcorso11]

this is what I get?????

[Hemoco]

You need to open the report with the report builder.
Go to the sql tab and paste the SQL code
Execute the report to see if you get the desired results.
Save the report.

[jcorso11]

ok. so that fixed my messup, but how do i do the original task at hand!

[Hemoco]

This means that you deleted the original view.

If you run the second part, it will be recreated.

[jcorso11]

i get Invalid object name 'dbo.Web30repRPCserverunavailable'

on the first part

[Hemoco]

Please launch this script from the lsmanage.exe tool (database scripts) to restore the original view.

Alter VIEW dbo.Web30repRPCserverunavailable
AS
SELECT     TOP 100 PERCENT Computername AS Computer, ErrorText, MAX(Lastchanged) AS [Last changed]
FROM         dbo.tblerrors
GROUP BY Computername, ErrorText, CFGname
HAVING      (ErrorText LIKE '%RPC server is unavailable%') AND (CFGname = 'WMIERROR')
ORDER BY MAX(Lastchanged) DESC

If the view was deleted for some reason try

Create VIEW dbo.Web30repRPCserverunavailable
AS
SELECT     TOP 100 PERCENT Computername AS Computer, ErrorText, MAX(Lastchanged) AS [Last changed]
FROM         dbo.tblerrors
GROUP BY Computername, ErrorText, CFGname
HAVING      (ErrorText LIKE '%RPC server is unavailable%') AND (CFGname = 'WMIERROR')
ORDER BY MAX(Lastchanged) DESC