locked
List all servers having "Name" 'Log \ FlightRecorder \ Enabled' "Value" 'False' RRS feed

  • Question

  • Hello,

    I need to identify all servers which have Microsoft SQL Server Analysis Services installed and "Name" 'Log \ FlightRecorder \ Enabled' "Value" 'False'.

    Any SCCM report for this?

    Also I will need to disable it (the Log\Flight Recorder\Enabled property in SQL Server Analysis Service Property) as recommended by the best practices so this imply to change one setting from "true" to "false" is it feasible?

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager



    • Edited by Felyjos Friday, May 25, 2012 8:52 PM
    Thursday, May 24, 2012 8:28 PM

Answers

  • CM07 does not collection this data, you will need to first collect this data then you can create a report on it. IMO you need step is how to define how you manualy collect this data, then start working on to automate this data collection.


    http://www.enhansoft.com/

    Friday, May 25, 2012 10:17 PM
  • Now that you have the manual steps, your next step is to convert the SQL into a vb script, which you can run on every PC. I would also including in the step writing the results out to WMI.


    http://www.enhansoft.com/

    Tuesday, May 29, 2012 9:15 PM
  • Thanks for the advices, I am running the SQL vbs now with some issues, I am looking to solve...

    http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/f7da3636-8954-4162-ba30-a0cf1b98daf8

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager


    • Edited by Felyjos Wednesday, May 30, 2012 4:49 AM
    • Proposed as answer by Garth JonesMVP Sunday, June 24, 2012 6:02 PM
    • Marked as answer by Garth JonesMVP Sunday, November 18, 2012 4:31 AM
    Wednesday, May 30, 2012 4:47 AM

All replies

  • CM07 does not collection this data, you will need to first collect this data then you can create a report on it. IMO you need step is how to define how you manualy collect this data, then start working on to automate this data collection.


    http://www.enhansoft.com/

    Friday, May 25, 2012 10:17 PM
  • Thanks Garth, I will look at this.

    For now I have two ways to update this setting I will look at a way to do it through scripts or queries...:

    1. Manual Steps:

    Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio > Server Type: Analysis Services Server Name : <<>> Click Ok Right Click <<Server Name>> (Microsoft Analysis Services) Properties Highlight Log\Flight Recorder\Enabled Drop Down list in column “Value” Select False Click OK

    Or

    2. SQL Query (Thanks Donald):

    Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio > Server Type: Analysis Services Server Name : <<>> Click Ok Click New Query Paste the following statement <Alter AllowCreate="true" ObjectExpansion="ObjectProperties" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object /> <ObjectDefinition> <Server xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200"> <Name>{SERVERNAME}</Name> <ServerProperties> <ServerProperty> <Name>Log\FlightRecorder\Enabled</Name> <Value>false</Value> </ServerProperty> </ServerProperties> </Server> </ObjectDefinition> </Alter> Replacing {SERVERNAME} with the server/instance name for each server would be the problem with 200 servers. ASCMD (http://msdn.microsoft.com/en-us/library/ms365187(v=SQL.90).aspx) is an excellent tool for handling this type of process. You can utilize parameters in your input file. For example, for the <Name> property line, the following can be used: <Name>$(ASCMDSERVER)</Name> Execute

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager


    • Edited by Felyjos Tuesday, May 29, 2012 4:57 PM
    Tuesday, May 29, 2012 4:56 PM
  • Now that you have the manual steps, your next step is to convert the SQL into a vb script, which you can run on every PC. I would also including in the step writing the results out to WMI.


    http://www.enhansoft.com/

    Tuesday, May 29, 2012 9:15 PM
  • Thanks for the advices, I am running the SQL vbs now with some issues, I am looking to solve...

    http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/f7da3636-8954-4162-ba30-a0cf1b98daf8

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager


    • Edited by Felyjos Wednesday, May 30, 2012 4:49 AM
    • Proposed as answer by Garth JonesMVP Sunday, June 24, 2012 6:02 PM
    • Marked as answer by Garth JonesMVP Sunday, November 18, 2012 4:31 AM
    Wednesday, May 30, 2012 4:47 AM