tblComputers.computername became integer after upgrade to 4

[simpsin]

Hi,

We upgraded to 4 without any hickups.

And as excpected some of the reports need correcting.. but we found a major issue.

All reports that use the tblComputers.Computername table are not correct.

For some reason, the tblCaomputers.Computername is not a string/text/varchar anymore but a Integer value.

Is this an upgrade error or by design?

Thanks
Regards

[tessymay]

THANKYOU!!

[Hemoco]

You most likely want computernames starting with 'cc'

Computername: integer field, used for the linking to other tables:
Computerunique: unique field domain\computername\siteid
Computer: name of the computer (this was field computername in 3.x)

Change report to this:

Select Top 1000000 tblComputers.Computername,tblComputers.Computerunique, tblComputers.Username,
tblComputers.LastknownIP, tblComputers.LastActiveScan,
tblOperatingsystem.Description
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Where tblComputers.Computer Like 'cc%'
Order By tblComputers.Computer

[tessymay]

Select Top 100 Percent tblComputers.Computername, tblComputers.Username,
tblComputers.LastknownIP, tblComputers.LastActiveScan,
tblOperatingsystem.Description, tblComputers.ComputerUnique
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Where tblComputers.ComputerUnique Like 'cc%'
Order By tblComputers.ComputerUnique

[tessymay]

I have created reports to show the computers by department. Mine also no longer works since the upgrade and I checked the computerunique field but it still finds no computers for any of the reports??

[Hemoco]

tessymay wrote:
I have created reports to show the computers by department. Mine also no longer works since the upgrade and I checked the computerunique field but it still finds no computers for any of the reports??

Please post the sql code of a not-working report.

[Hemoco]

On most reports you can just add this field to make it work.

[simpsin]

Holy Crap..

OK Thanks.

I did a full roll back to 3.6, we will need to re-evaluate the migration path as most of our in hous reports (about 50 or so) used the tbl.Computers.Computername field, with links and excludes and everything.



So we will need to redo from scratch all our reports.



Regards

[Hemoco]

This is by design, you need to add the field "computerunique" to your report and it will display nicely in the web interface.