I have just written a report to list all computers in the system. As I have added a link to tblCompCust, any computers with no entry in this table are ignored as they effectively have a state of Null.
If I go to custom pages and click 'save changes' it adds a line to this table with state 1 and it reports ok.
I am presuming that as all of data has been imported from lspush files, it hasn't automatically set these computers to active.
I have amended the SQL query for this report to ignore Null entries to get the correct output, but I would have thought that the default state for a new machine would be 1 rather than Null.