
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2010 10:44 AM
Hello,
I have a few reports that are not working due to the upgrade.
This was a report that displayed computers that had Custom department field empty
Please Advise
I have a few reports that are not working due to the upgrade.
This was a report that displayed computers that had Custom department field empty
Select Top 100 Percent dbo.tblComputers.Computername, dbo.tblComputers.LastknownIP, dbo.tblComputers.Lastseen As [Last Seen], dbo.tblComputers.Firstseen As [First Seen], dbo.tblCompCustom.Department From dbo.tblComputers Inner Join dbo.web30repallcompstates On (dbo.tblComputers.Computername = dbo.web30repallcompstates.Computername) Left Outer Join dbo.tblCompCustom On (dbo.web30repallcompstates.Computername = dbo.tblCompCustom.Computername) Where dbo.tblCompCustom.Department Is Null Or dbo.tblCompCustom.Department = '' Order By dbo.tblComputers.Computername
Please Advise
Labels:
- Labels:
-
Archive
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2010 09:59 AM
Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.LastknownIP,
dbo.tblComputers.Lastseen As [Last Seen], dbo.tblComputers.Firstseen
As [First Seen], dbo.tblCompCustom.Department, dbo.tblComputers.ComputerUnique
From dbo.tblComputers Left Join
dbo.tblCompCustom On dbo.tblCompCustom.Computername =
dbo.tblComputers.Computername
Where (dbo.tblCompCustom.Department Is Null) Or
(dbo.tblCompCustom.Department = '')
Order By dbo.tblComputers.Computername

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2010 09:24 AM
Okay then how can I get a report that shows "Department" field in "Custom fields"
as empty ?
as empty ?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2010 08:19 AM
Report has an invalid syntax:
Invalid object name 'dbo.web30repallcompstates'.
Invalid object name 'dbo.web30repallcompstates'.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2010 08:51 AM
Ismail wrote:
Report has an invalid syntax:
Invalid object name 'dbo.web30repallcompstates'.
dbo.web30repallcompstates doesn't exist anymore

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2010 05:47 PM
What is the exact error?
