Ghost Solution Suite

 View Only

  • 1.  Presales GSS 2.0

    Posted May 08, 2007 03:53 PM
    I am looking to provide my company with SQL Reports based off the information that I gather from the Ghost Console.  From my understanding the Console stores the information it gathers into an MSDE or SQL database.

    Is anyone currently doing this, or attempted to do this with success?


  • 2.  RE: Presales GSS 2.0

    Posted May 08, 2007 09:45 PM
    Hi Chris,

    Although info is not in the manual - Ghost uses Sybase DB and so with the right knowledge you should be able to execute standard SQL queries to get the data you need.


  • 3.  RE: Presales GSS 2.0

    Posted Jun 06, 2007 09:24 PM
    I'd be very, very curious - to the point of being willing to pay fees - to anyone that has this working.
     
    I have been told by Symantec support on multiple occasions and regarding multiple versions that the only way to access the Ghost database is through the Ghost Console and that the database is proprietary, etc.
     
    Anyone?
     
    Anyone?
     
    Bueller?
     
    Bueller?


  • 4.  RE: Presales GSS 2.0

    Posted Jun 07, 2007 09:29 AM
    I hadnt looked before gss 1 but from then till 2.01 sybase/symantec installs an ODBC driver for its database.  From the console you can get the DB password/username combo and put them in to the ODBC driver on the server.  You will probably want to unselect the option that stops the Database upon ODBC disconnect.  From there you can write your own code to use the ODBC driver or use access and link to it and write queries or change data.
     
    I wrote some code to update certain WMI entries with specific info that I can query with dynamic group filters to get desired machines in a list.  When I let inventory refresh run against 1600 computers my database ballooned to 9GB and the console ran like a turd after that.

    Message Edited by David.Poprik on 06-07-200706:32 AM



  • 5.  RE: Presales GSS 2.0

    Posted Jun 07, 2007 11:39 AM
    I was under the impression from the GSS 2.0 information that you could use a SQL Server if you already had one.  This would definately make things easier.


  • 6.  RE: Presales GSS 2.0

    Posted Jun 07, 2007 11:50 AM
    I will defer to a symantec technician on that one but I was never presented with an option to use one either during upgrade or fresh install of the console server.  Perhaps they are simply referring to the fact that it is an SQL style database and you can use generic SQL commands to address it?

    Message Edited by David.Poprik on 06-07-200708:51 AM



  • 7.  RE: Presales GSS 2.0

    Posted Jun 07, 2007 11:52 AM
    We certainly have plenty of SQL server things going on.  Has anyone actually accessed the GSS2.0x information via ODBC with SQL Server or MSAccess?
     
    For straight-up reporting, I'd prefer MSAccess for the ease of report creation, but I'm not going to be picky until after I've got into the information.
     
    Thanks for the responses & help so far - there might actually be a way to skin this cat.


  • 8.  RE: Presales GSS 2.0

    Posted Jun 07, 2007 12:06 PM
    I have linked to it with access and done some rudimentary things while working on my code to check results of the modifications the code was making.  There is no reason a query wouldnt work via access. 
     
    If you are looking for something specific from the database I doubt many have done queries.  It might be best to DL the trial and install access with the console and link to the Database to see if you can get what you want from it.