Video Screencast Help
Search Video Help Close Back
to help

OpsCenter 7.5.0.4 and reporting on 32 bit Linux clients on NBU 6.5

Created: 25 Feb 2013 | Updated: 23 May 2013 | 7 comments
StarSister's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

Hi, I'd just like to double check in case anyone knows of a workaround/fix. I am backing up 32 bit Linux clients via the 6.5 client to 5220 appliance - but the OPsCenter does not see these for reporting?

Can someone please confirm if this is the expected result, and if there is any workaround?  

Discussion Filed Under:

Comments 7 CommentsJump to latest comment

StarSister's picture

I should point out that I am trying to run the following report:

Report templates>backup>status>week at a glance:

If I do not choose a client name or any variables I am able to see ALL clients (which does include my 32bit LInux clients), however when I wish to choose one of these clients so that it's *just* that client in the report, it does not appear in the picklist under client name..........

0
Login to vote
StarSister's picture

It seems it is not occuring for just the 32bit linux clients - but another OS too. I don't know why they are not appearing on the client dropdown list, however I can view them by using the following operand:

 

Client name 'contains'  servername%

 

and this then shows me the report for the one client, still doesn't explain why the clients don't show in the dropdown picklist though.

0
Login to vote
tom_sprouse's picture

StarSister,

It maybe that for some reason the client(s) may be flagged inactive in the database.

What version of OpsCenter are you running? You should at least upgrade to 7.5.0.4 and 7.5.0.5 was release on 2/20/2013.

If you are able to ugprade, I would suggest going to 7.5.0.5

Are these Linux clients VM's?

--Tom

 

Note: If this post provides you with a solution don't forget to mark the discussion as solved&l

0
Login to vote
StarSister's picture
Hey Tom,
 
Yes, these linux clients are vm's.
 
I have Version 7.5.0.4 of OpsCenter, and my appliances have just recently been patched up to 2.5.1. 
Thank you for your advice, I do believe upgrading would be an option.
 
On another note some clients appear with their FQDN, and some just have the server name - is this what you would mean re the inactive in the database?
 
I have had issues today when viewing dashboards and reports with the error 'an unknown exception has occured' a reboot of the opscenter server appeared to cure this, however I am unsure what might cause this?
 
Many Thanks again Tom,
 
Cheers
0
Login to vote
tom_sprouse's picture

StarSister, 

If you have Analytics, or the ability to run a custom SQL against the DB, execute the following:

 

SELECT * FROM domain_client WHERE name LIKE 'clientname%'

Then look for the column, isActive (I think, as I currently do not have a db in front of me)

if the isActive column is set to 1, then the client should show in the reports and the GUI.

If the isActive = 0, then the client is flagged / turned off (for multiple reasons) but VM's tended to do this in 7503.

You can modify the isActive column, however, I highly suggest opening a case with Support to have this performed.

If you have any questions, please let me know.

--Tom

 

Note: If this post provides you with a solution don't forget to mark the discussion as solved&l

0
Login to vote
StarSister's picture

Tom, thank you so much for your reply.

 

I don't have analytics - do you know if I can run queries on the database even if I don't have analytics?

Many Thanks

0
Login to vote
tom_sprouse's picture

Yes you can run queiries against the database using the dbisqlc utility...

Technote: http://www.symantec.com/docs/TECH173778

Explains how to get into DBISQLC

 

With Windows Explorer, navigate to C:\Program Files\Symantec\OpsCenter\server\db\WIN64
Launch the program "dbisqlc.exe" from this location.
To connect to the database with dbisqlc, enter:
User ID: DBA
Password: SQL
Click on Database Tab
Uncheck "Stop database after last disconnect"
Server name: opscenter_'hostname'     (example Server name: opscenter_myservername)

Click on OK

In the lower screen of dbisqlc labeled "Command", enter the sql:

 

SELECT * FROM domain_client WHERE name LIKE 'clientname%'

Note: If this post provides you with a solution don't forget to mark the discussion as solved&l

SOLUTION
0
Login to vote