Tips and Tricks
From Wiki
How to Move the Ecora Auditor Database (MSDE)1. Locate the MSDE database files *.mdf. By default, these files are located in the following folder: %Program Files%\Microsoft SQL Server\MSSQL$ECORA\data. 2. Click Start, then Run, type cmd, and press ENTER. 3. Start the Osql.exe tool. To do this, type osql -E -S ServerName\InstanceName at the command prompt, where ServerName is the name of the server where the MSDE database files are located, and where InstanceName is the name of the instance of MSDE, and then press ENTER. 4. At the osql command prompt, back up the existing configuration and content databases. To do this, type the following at the osql command prompt BACKUP DATABASE ecora TO DISK = 'PathName' where ecora is the name of the MSDE database, and where PathName is the path and file name that you want, such as %MSDE%\Backup\ecora.bak. 5. Type GO, and then press ENTER. 6. Repeat steps 4 and 5 for each database. 7. Detach the database. To do this, type EXEC sp_detach_db 'EcoraAuditorDB' at the command prompt, where EcoraAuditorDB is the name of the MSDE configuration database, and then press ENTER. 8. If you receive a message that the database is in use and cannot be detached, start a new command prompt. At the new command prompt, type the following, and then press ENTER after each line:
8. Start another command prompt, or start Microsoft Windows Explorer, and then copy the MSDE database files that you located in step 1 to the new folder that you want. 9. Attach the configuration database. To do this, type the following at the command prompt where the Osql.exe tool is running. EXEC sp_attach_db @dbname = ‘%ecora_database%’, @filename1 = 'C:\new_database_location\%ecora_database%.mdf', @filename2 = 'C:\new_database_location\%ecora_database%.ldf' (assuming the database location is on the C: drive) 10. At the command prompt, type quit, and then hit ENTER to quit the Osql.exe tool. How to save a report on a network drive?A quick guide how to save a report on a network drive 1. Under Ecora Auditor main menu for each particular module, the user needs to select the “Scheduled Tasks” tab. In this particular example, the scheduled task is already created, however a new task may be created.  2. Select the scheduled task defining the report that needs to be saved on a custom location with a right click of the mouse button. Choose the “Edit…” menu if the task is already created and scheduled. The following window will open  3. In the window opened in Step 2, under “Save Report To” the user needs to select the “Browse…” button and navigate to the custom location where the report needs to be saved. This location can be local or network location. Under the blank field, the default name for the reports is “%date_%time”, which will give a time stamp to the report. If the user desires a custom name for the file, they need to input the name in that field.  How to create custom directory settings in Ecora Auditor?1. There are numerous ways to create custom xml file defining the parts of the directory structure, under which Ecora Auditor will look for the attributes defined in any given report, thus here one of them is presented. For further modification of each of the custom xml files they can be opened in word pad manually, or edited in Ecora Auditor. First the user needs to select the relevant module, Windows in this example. Then select Collect and leave to defaults (Choose Interactively for both System Group and Attribute Group)  2. Proceed to base the collection on a previously defined System Group and custom report (there is variety of ways to proceed, however this is one of the best illustrations of this technique.) If the custom report would require information from the file structure, then the user would be prompted to create a custom xml file containing the necessary definitions.  3. The user can either browse to a previously created xml file with custom directory settings, or select the option to create a new file, which will be used in that collection.  4. With either selections the user will be prompted to work with the following layout.  The first field denotes the first choice for custom directory, from which Ecora will collect the attributes specified in the report. In this particular example that is the Windows root directory “C:”. The second field contains custom defined criteria and may be left blank. The next field denoted as “Levels” will specify the depth of collection for Ecora. For example “0” as an argument will force Ecora to collect from the root directory only, “1” will force Ecora to collect from the root directory along with the first level directory structure (e.g. “Program Files”, “Windows”, etc.), “2” will scan the root directory, the first level directory structure in the root directory, and the first level directory structure of each directory in the root directory, and so on. The argument “-1” will force Ecora to scan through the entire directory structure. The next field denoted as “Folders Only” will select whether Ecora will scan the folders only, or the folders and the files contained in each folder. “Checksum” will force Ecora to check for particular checksums for particular files, which will slow the collection significantly. Finally, the field denoted as “Exclude Directory” allows the user to exclude specific directories from each collection. This feature is particularly useful when large set of directories need to be scanned with the exception of one or two large directories. When done, the user can proceed with the next line, selecting another directory, i.e. “D:”. Once the user makes all the selections, they need to select OK from the menu, name the file appropriately and proceed with the collection. This custom xml file will remain active and can be used for other collections, etc., however only one custom xml file can be used per collection. The custom file is located in “%:\Documents and Settings\All Users\Application Data\Ecora\Auditor45\windows\Custom Files.” How to schedule and run multiple tasks with one click?1. Create a scheduled task. This task could be empty, or a collection related to the multiple reports that need to be ran.
  2. Create the tasks you want to perform and run ad hoc as a group.
 3. When an ad hoc reporting is needed
 How to change the default report template?1. From the File choosing Preferences-->Output Formats-->Advanced button will allow changing the default report style. The built-in default style itself cannot be changed, therefore first a new style needs to be created by selecting the New button, then giving the new style a name, e.g. "New Style". 2. The new style can be renamed or deleted by selecting it, and then choosing the corresponding buttons. Once the new style appears in the left pane, it can be selected and edited by choosing the Edit button. 3. A menu will open allowing fully customizable report style. In the example bellow, the font in the body of the report has been set as 12 points Arial, in red color on white background and italic. Auditor Professional allows full customization of the report style per customer specifications.  How to search for custom registry keys?How to add a custom company logo to your reports?1. Copy the desired image to your Auditor Professional installation folder (typically C:\Program Files\Ecora\Auditor45) or another desired location.
 2. Launch Ecora Auditor Professional. 3. Go to File>Settings.  4. Choose the Preparer tab and click on Logo.  5. Browse to the logo file location and select it.  6. Click OK. 7. Generate a Report. The logo will now be displayed in the top-right corner of the Report. 
|
