Symantec ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0 Manual Download Page 116

Page: 116 / 199

SQL Servers Cube

– Contains the data regarding the operating SQL servers in

the environment.

Dimensions

■

Computer

■

SQL Cluster

■

SQL Cluster Resource

■

SQL Database

■

SQL Database Creation Date

■

SQL Database System

■

SQL Storage Area

■

SQL User

Measures

Cluster Resource Count

The number of cluster resources.

Cluster Count

The number of clusters.

Database System Count

The number of database systems.

Database Count

The number of databases.

Storage Area Count

The number of storage areas.

User Count

The number of SQL users.

Cube reference

SQL Servers Cube

116

Summary of Contents for ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0

Page 1: ...IT Analytics Solution for Symantec User Guide Version 7 0 SP2 ...

Page 2: ...ROVIDED ASIS ANDALLEXPRESSORIMPLIEDCONDITIONS REPRESENTATIONS AND WARRANTIES INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY FITNESS FOR A PARTICULAR PURPOSE OR NON INFRINGEMENT ARE DISCLAIMED EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BELEGALLYINVALID SYMANTECCORPORATIONSHALLNOTBELIABLEFORINCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING PERFORMANCE OR USE OF THI...

Page 3: ...Symantec Corporation 350 Ellis Street Mountain View CA 94043 http www symantec com ...

Page 4: ...ing and Symantec Security Response to provide alerting services and virus definition updates Symantec s maintenance offerings include the following A range of support options that give you the flexibility to select the right amount of service for any size organization Telephone and Web based support that provides rapid response and up to the minute information Upgrade assurance that delivers autom...

Page 5: ... Endpoint Protection connection fields 24 Adding Symantec Endpoint Protection connections 25 Editing Symantec Endpoint Protection connections 25 Deleting Symantec Endpoint Protection connections 26 Configuring the ServiceDesk connection 26 ServiceDesk connection fields 27 Editing the ServiceDesk connection 28 Deleting the ServiceDesk connection 28 Adding cubes 29 Adding reports 29 Configuring the ...

Page 6: ... 50 Creating a pivot table using the Computer cube example 51 About Key Performance Indicators KPIs 52 Creating Key Performance Indicators KPIs 53 Setting the status of a KPI advanced 54 Chapter 4 Granting access to IT Analytics Solution 57 About security 58 SQL Server Database Engine 58 SQL Server Analysis Services 59 Granting access to cubes using the Symantec Management Console 60 Adding a user...

Page 7: ...2 IIS Servers Cube 83 Installed Files Cube 84 Installed Software Cube 85 Monitor Metrics Cube 86 Monitor NT Events Cube 90 Monitored Processes Cube 91 Package Distribution Events Cube 93 Package Server Configuration Events Cube 94 Package Server Status Cube 95 Patch Management Cube 96 ServiceDesk Changes Cube 97 ServiceDesk Incidents Cube 100 ServiceDesk Problems Cube 104 ServiceDesk Releases Cube...

Page 8: ...128 Software Installs Dashboard 128 Symantec Endpoint Protection Client Dashboard 128 Symantec Endpoint Protection Risk Dashboard 128 Vista Readiness Dashboard 128 Windows 7 Readiness Dashboard 129 Appendix C Report reference 131 Add Remove Programs by Name 134 Add Remove Programs Search 134 Advertisement Execution Event Summary 134 Alert and Task Details 135 Application Metering by File Name 135 ...

Page 9: ...lity Monthly 140 Package Server Availability Daily 140 Patch Management Bulletin Summary 140 Patch Management Details 140 Patch Vulnerability 141 Patch Vulnerability Search 141 Scan Trend 141 Servers by Type and Version 141 ServiceDesk Change Search 141 ServiceDesk Changes by Assigned to User 141 ServiceDesk Changes by Impact 142 ServiceDesk Changes by Priority 142 ServiceDesk Changes by Status 14...

Page 10: ...ense Trend 147 Top 10 Applications Consuming CPU 147 Top 10 Applications Consuming Memory 147 Top 10 Users Consuming CPU 147 Virus Alert Details 147 Virus Alert Trend 147 Virus Definition Distribution Details 148 Vista Readiness Details 148 Windows 7 Readiness Details 148 Appendix D Dimension Attribute reference 149 Add Remove Programs 155 Asset 155 Asset Status 155 Asset Type 156 Computer 156 Cos...

Page 11: ...le Alert Action Audit Type 168 Event Console Alert Category 168 Event Console Alert Severity 168 Event Console Monitor Rule 168 File 169 Filter 169 IIS FTP Site 169 IIS Server 169 IIS Virtual Directory 170 IIS Web Site 171 Last Basic Inventory Date 172 Location 172 Logical Disk 172 Monitor Metric 173 Monitor Metric Detail Level 173 Monitor Metric Instance 173 Monitor Metric Source 173 Monitor NT E...

Page 12: ...ceDesk Change Priority 178 ServiceDesk Change Source 178 ServiceDesk Change Status 179 ServiceDesk Change Type 179 ServiceDesk Change Urgency 179 ServiceDesk Contact Type 179 ServiceDesk Created by User 179 ServiceDesk Date Closed 180 ServiceDesk Date Due 180 ServiceDesk Date Ended 180 ServiceDesk Date Implemented 181 ServiceDesk Date Modified 181 ServiceDesk Date Needed 181 ServiceDesk Date Opene...

Page 13: ...erviceDesk Resolved by User 187 ServiceDesk Time Closed 188 ServiceDesk Time Due 188 ServiceDesk Time Ended 188 ServiceDesk Time Implemented 189 ServiceDesk Time Modified 189 ServiceDesk Time Needed 189 ServiceDesk Time Opened 189 ServiceDesk Time Resolved 190 ServiceDesk Time Reviewed 190 ServiceDesk Time Scheduled 190 ServiceDesk Time Started 190 ServiceDesk User 191 Software Component 191 Softw...

Page 14: ...SQL Cluster Resource 193 SQL Database 194 SQL Database Creation Date 194 SQL Database System 194 SQL Storage Area 195 SQL User 195 Task 195 Task Server 195 Time 196 User 196 Index 197 Contents 14 ...

Page 15: ...and effectively IT Analytics Solution represents the information and relationships that are at the core of the IT decision making process The result is a robust multi dimensional model that provides an entirely new way to explore and view IT data It enables users to answer dynamic sequences of questions as fast as they are asked The focus shifts to thought leadership and positive change within the...

Page 16: ...cubes through pivot tables IT Analytics Solution is the foundation solution that provides all of the functional components The solution is a prerequisite solution for IT Analytics Packs that does not require a license similar to Symantec Management Platform However on its own IT Analytics Solution does not contain any cubes or reports The actual definitions for the cubes reports and dashboards are...

Page 17: ...tion Configuring IT Analytics Solution Configuring Symantec Endpoint Protection connections Symantec Endpoint Protection connection fields Adding Symantec Endpoint Protection connections Editing Symantec Endpoint Protection connections Deleting Symantec Endpoint Protection connections Configuring the ServiceDesk connection ServiceDesk connection fields Editing the ServiceDesk connection Deleting t...

Page 18: ...ts the hardware prerequisites and install specific software before you install IT Analytics Solution See Hardware prerequisites on page 20 See Software prerequisites on page 20 Verify that your computer meets the hardware prerequisites and that the proper software is installed and configured Step 1 You can install IT Analytics Solution from within the Symantec Installation Manager See Installing I...

Page 19: ...s See Configuring the ServiceDesk connection on page 26 Optional Configure the ServiceDesk connections Step 6 You can choose the cubes that you want to include in your environment See Adding cubes on page 29 Add the cubes Step 7 You can choose the reports that you want to include in your environment See Adding reports on page 29 Add the reports Step 8 You can choose how often each installed cube i...

Page 20: ...05 SP2 and 2008 SP1 For more information about proper configuration see the Microsoft MSDN Web site at http msdn2 microsoft com en us library ms143764 aspx Microsoft SQL Server Reporting Services for IT Analytics Reports Supported versions 2005 SP2 and 2008 SP1 For more information about proper configuration see the Microsoft MSDN Web site at http go microsoft com fwlink LinkID 91847 We recommend ...

Page 21: ...otection Pack IT Analytics Asset Management Pack and IT Analytics ServiceDesk Pack 5 Click Review Selected Products 6 Click Next 7 Follow the rest of the installation instructions Licensing IT Analytics Solution IT Analytics Solution is installed with a seven day trial license For an extended trial or to purchase IT Analytics Solution contact Altiris Sales For more information on registering your ...

Page 22: ...nd saved 7 Under Analysis Server Database select an Analysis Server Database For a new standard configuration in the Create New Database box accept the default to create a new Analysis Server Database with the IT Analytics name If you select an existing database note that the existing data sources are overwritten with the current Symantec Management Platform database settings 8 Click SaveDatabaseS...

Page 23: ...od is recommended when the users that access Reporting Services are not in Active Directory or are not in the same domain 13 Click SaveFolderSettings and confirm that the Report Folder name is verified and saved 14 Optional Click the Optional Settings tab and verify that the Report Integration URLs contain the correct Symantec Management Platform name If necessary you can click Edit URLs to make c...

Page 24: ...c Endpoint Protection connections on page 26 See Configuring Symantec Endpoint Protection connections on page 23 Table 2 2 Fields for Symantec Endpoint Protection connections Description Field The name of the server that hosts the Symantec Endpoint Protection Manager database SEP Database Server Name The name of the Symantec Endpoint Protection Manager database The default database name and schema...

Page 25: ...ntec Endpoint Protection connection fields on page 24 5 Click Apply Editing Symantec Endpoint Protection connections IT Analytics Solution lets you edit Symantec Endpoint Protection connections so that data can be leveraged for reporting purposes See Adding Symantec Endpoint Protection connections on page 25 See Deleting Symantec Endpoint Protection connections on page 26 See Configuring Symantec ...

Page 26: ...ymantec Endpoint Protection connections on page 25 See Configuring Symantec Endpoint Protection connections on page 23 See Installing and configuring IT Analytics Solution on page 18 To delete Symantec Endpoint Protection connections 1 From the Symantec Management Console on the Home menu click IT Analytics 2 In the left pane expand the Settings Connections folders 3 Click Symantec Endpoint Protec...

Page 27: ...k connection on page 28 See Deleting the ServiceDesk connection on page 28 See Configuring the ServiceDesk connection on page 26 See Installing and configuring IT Analytics Solution on page 18 Table 2 3 Fields for ServiceDesk connections Description Field The name of the server that hosts the ServiceDesk database ServiceDesk Database Server Name The name of the ServiceDesk database ServiceDesk Dat...

Page 28: ...e ServiceDesk connection fields on page 27 Report Integration URL which lets you specify an alternate base URL to access the Process Viewer page for this ServiceDesk instance The IT Analytics reports uses this URL to launch a specific incident to display further details 5 Click Apply Deleting the ServiceDesk connection IT Analytics Solution lets you delete the ServiceDesk connection to remove its ...

Page 29: ...rify that the cubes were successfully created by clicking the Installed tab and then review the list of cubes Adding reports You can add reports to your environment that match your needs See Installing and configuring IT Analytics Solution on page 18 To add reports 1 In the Symantec Management Console on the Home menu click ITAnalytics 2 In the left pane expand the Settings Reports folders 3 In th...

Page 30: ...u want for the default processing tasks and then click Enable Schedule 4 Check the box for each available cube that you want to be processed on the current schedule For a typical configuration select all cubes 5 Click Save Changes and confirm that the Default Processing Task is saved 6 Click Run Now The selected Processing Tasks starts asynchronously which means that the task won t finish by the t...

Page 31: ...and then uninstalling IT Analytics Solution itself Table 2 4 Process for uninstalling IT Analytics Description Action Step You can use Symantec Installation Manager to remove your IT Analytics Packs See Removing the IT Analytics Packs on page 31 Remove the IT Analytics Packs from Symantec Management Platform Step 1 You can use Symantec Installation Manager to safely remove IT Analytics Solution Se...

Page 32: ... 4 To confirm the uninstall process click Yes 5 On the Uninstallation Complete page click Finish Hosting Symantec Management Platform and SQL 2005 Reporting Services on the same server You need to perform some additional configuration to host the instance of SQL Server 2005 Reporting Services that IT Analytics Solution uses The configuration changes let Reporting Services work on the same server a...

Page 33: ...opriate IP address and port settings In the IPAddresses drop down list the default is usually AllUnassigned However you can specify that this Web site is configured to a specific IP address Change this box only if you know the appropriate setting For the TCP port use a port that is not currently in use by another Web site under IIS You can check the ports that other Web sites use by clicking Prope...

Page 34: ...uses If you can t tell if the application pool is different you can create a new application pool in this window You can then use that application pool for both drop down lists 27 Click Apply 28 Launch the Symantec Management Console 29 On the Home menu click IT Analytics Settings Connections 30 Under Reporting Server next to the Report Server Virtual Directory URL setting click the edit symbol 31...

Page 35: ...l To install all of the available reports in the header row of the table click Install 37 Click Apply A progress window launches 38 Once the Close symbol is enabled click it 39 Ensure that you can access the dashboards and reports 35 Installing and configuring IT Analytics Solution Hosting Symantec Management Platform and SQL 2005 Reporting Services on the same server ...

Page 36: ...Installing and configuring IT Analytics Solution Hosting Symantec Management Platform and SQL 2005 Reporting Services on the same server 36 ...

Page 37: ...t Creating a new report About Pivot tables Pivot table prerequisites Pivot table fields Top pivot toolbar functions Pivot toolbar functions Pivot charts toolbar functions Saving a pivot table view Loading a pivot table view Modifying a pivot table view Deleting a pivot table view About displaying pivot data results Displaying results in a pivot chart 3 Chapter ...

Page 38: ...ot table using the Computer cube example About Key Performance Indicators KPIs Creating Key Performance Indicators KPIs Setting the status of a KPI advanced Accessing IT Analytics Solution You can access IT Analytics Solution in many ways Implementing IT Analytics Solution Accessing IT Analytics Solution 38 ...

Page 39: ...you a representative view of your IT assets You can export the reports to many different formats including HTML Excel and PDF You can also create additional reports by using the SQL Reporting Services Report Builder and then easily import your reports in IT Analytics Symantec Management Console Dashboards Reports With the built in Cube Browser you can view cube data natively through the SQL Server...

Page 40: ...2 In the left pane expand the Content folder 3 Click Reports 4 Select a report to view Creating a new report You can create new SQL Server Reporting Services reports by using the SQL Server Reporting Services Report Builder The SSRS Report Builder provides you with access to the IT Analytics Cubes that let you create the customized reports that you can distribute Report Builder is a client side ap...

Page 41: ...ping until the report displays the way that you want it to For example you can drag and drop data value fields series fields or category fields 12 Name your report 13 Click Run Report on the toolbar to ensure the report renders properly If the report does not run correctly click Design Report on the toolbar and make the necessary changes 14 Click Save on the toolbar to save your report Save your r...

Page 42: ...Pivot table prerequisites You must install the Microsoft Office Web Components to work with an interactive pivot table in your browser If the freely available components are installed and you don t have Microsoft Office already installed you can view the components with reduced functionalities For instructions on how to download and install the Office Web Components see http www microsoft com down...

Page 43: ...ld You can place added fields before or after the existing fields to modify the structure Drop Row Fields Here The aggregate count or summary results of the fields that are defined in the filter row and column fields Drop Totals or Details Fields Here Top pivot toolbar functions The following toolbar functions are available in the top toolbar See About Pivot tables on page 42 Table 3 2 Top pivot t...

Page 44: ...er Sort Ascending Sorts the selected column in descending order Click it to clear the current sort order and to select a new sort order Sort Descending Enables or disables the auto filter function IT Analytics Solution retains your filter settings as you toggle on and off the Auto Filter Fields that have an applied filter have a blue arrow at the selected field Auto Filter Changes the format with ...

Page 45: ...Legend Switches the x axis of the chart to either row headings or column headings and allows the displayed data to be represented correctly By Row Column Saving a pivot table view You can save pivot configurations or views in both chart formats and table formats Using this functionality you don t have to reconfigure the pivot views that you most commonly access In addition these saved views can be...

Page 46: ...Symantec Management Console on the Home menu click ITAnalytics 2 In the left pane expand the Pivot Tables folder 3 Click the cube that contains your saved view For example the Computer cube 4 From the toolbar at the top of the pivot page click Open 5 From the drop down list select the saved view to load 6 Click Open The page refreshes and displays the name of the view under the name of the cube Mo...

Page 47: ...th the current configuration Save as Existing View 10 Check Available to All Users if this view should be publicly available Otherwise leave the box unchecked default 11 Click Save The page refreshes and displays the name of the view under the name of the cube Deleting a pivot table view You can delete a pivot table view that you previously created See About Pivot tables on page 42 To delete a piv...

Page 48: ...he available fields on the chart or table by dragging and dropping fields from the Field List box You can also use filters to define the data for each field that you want displayed in the chart For example you can check Altiris Managed only See About Pivot tables on page 42 Table 3 5 Pivot data results display options Description Display option Lets you see a summary of the information in graphica...

Page 49: ...ole on the Home menu click ITAnalytics 2 In the left pane expand the Pivot Tables folder 3 Click the cube that you want to create a pivot table for For example the Computer cube 4 From the toolbar at the top of the pivot page click Display as Pivot Table Exporting pivot table results You can export data from a pivot table list to other programs such as Microsoft Excel If you want to further analyz...

Page 50: ...er domain For example if the hostname of the SQL Server Analysis Server is different than the hostname of Symantec Management Platform The site that the control accesses is not included in the list of trusted sites You need to change your Internet Explorer security settings so these warning messages do not appear To remove warning messages 1 In Internet Explorer on the Tools menu click Internet Op...

Page 51: ... example See About Pivot tables on page 42 To create a Computer cube pivot table 1 In the Symantec Management Console on the Home menu click ITAnalytics 2 Click Pivot Tables A list of available cubes displays 3 Choose the Computer cube 4 Click Field List The Pivot Table Field List displays the fields that are available within the cube You can add each of these fields to the pivot table to shape yo...

Page 52: ...al of making informed business decisions Analysis Services leverages this capability through Key Performance Indicators KPIs KPIs are defined as quantifiable measures that represent a critical success factor in an organization The emphasis is on the action of quantifying something in the environment For example the KPIs must be measurable to successfully be monitored and compared against a given o...

Page 53: ...mple of creating KPIs for computers with critical patch vulnerability defined through the cube The example highlights how this procedure automatically populates some of the MDX code that is needed to define the KPI To create KPIs 1 In the Symantec Management Console on the Home menu click ITAnalytics 2 In the left pane expand the Pivot Tables folder 3 Click Patch Management Cube 4 Click anywhere i...

Page 54: ... string you define your goal as 10 of all applicable computers With this measure in place any KPI value that is below our goal is acceptable Any value above our goal is an undesirable state where there are too many computers in the environment with critical patch vulnerabilities 14 Click Save Changes 15 Click OK to allow the window to refresh 16 In the left pane open the Settings folder 17 Click K...

Page 55: ...date Software Update Severity Critical Measures Vulnerable Computer Count 0 1 aggregate Software Update Software Update Severity Crit Measures Applicable Computer Count THEN 1 WHEN aggregate Software Update Software Update Severity Critical Measures Vulnerable Computer Count 0 25 aggregate Software Update Software Update Severity Cri Measures Applicable Computer Count THEN 1 ELSE 0 END 6 For Statu...

Page 56: ...Implementing IT Analytics Solution Setting the status of a KPI advanced 56 ...

Page 57: ...es Creating a role Deleting a role Granting access to cubes using SQL Server Management Studio SQL Server Reporting Services Granting access to reports for authorized users using the Symantec Management Console Granting access to reports for authorized users using the Report Manager Web site Granting access to the dashboards pivot tables and reports Symantec Management Platform role based privileg...

Page 58: ...e and have at least Symantec Guests role privileges They must also have access to the data within the Analysis Services cubes and reporting services reports to have full functionality For the standard security configuration users in the IT Analytics Users group already have access to the Altiris Guests Security role in Symantec Management Platform SQL Server Database Engine IT Analytics Solution p...

Page 59: ... This step is necessary whenever the database settings for Symantec Management Platform are altered If you need to make advanced configuration changes to the data sources you can directly manipulate the data sources by using SQL Server Management Studio For example you might want to change the host name or its credentials The configuration changes persist as long as the Analysis Server database is...

Page 60: ...gh the Symantec Management Platform You can also use a third party application that is designed for cube browsing including Microsoft SQL Server Management Studio Microsoft Excel ProClarity and others You can manage the user rights in Analysis Services through the user of roles To view a cube a user must be in a role that has read access to a cube Roles also let you control the fine grain details ...

Page 61: ...odify privileges for a role 1 In the Symantec Management Console on the Home menu click ITAnalytics 2 In the left pane expand the Settings folder 3 Click Cubes 4 In the right pane click the Security tab 5 Under Cube Read Access click to select or clear the check boxes you want Selecting the check box next to a cube grants members or the selected role access to that specific cube An empty box indic...

Page 62: ...Settings folder 3 Click Cubes 4 In the right pane click the Security tab 5 Under Roles select the role that you want to delete from the drop down list 6 Wait for the screen to refresh and then click Delete The screen refreshes again and a message displays at the top of the page which states that the role was successfully deleted 7 Click Apply Granting access to cubes using SQL Server Management St...

Page 63: ...s role permits You might need to configure Notification Server security to see the IT Analytics tab and installed cubes or reports SQL Server Reporting Services SQL Server Reporting Services is accessed during the configuration of the reporting services folder and its content The contents includes the data source reports that are used to access cubes as well as the installation of dashboards and r...

Page 64: ... page This functionality is similar to how Read access is administered for individual cubes Alternatively the Report Manager Web site within SQL Reporting Services can be used to manage user Read access to specific reports For reports to return data the account that you use must have at least Read access to the Analysis Server cubes that the report accesses Granting access to reports for authorize...

Page 65: ... pane navigate to the Security page 5 Click New Role Assignment 6 In the Group or user name box enter IT Analytics Users 7 Select the browser role 8 Click OK Members of this role now have the appropriate rights to view the reports that this role permits You might need to configure Notification Server security to see the IT Analytics tab and any installed cubes or reports 9 Optional If the IT Analy...

Page 66: ...new member s 6 In the Name Query box select Starts With 7 Enter IT Analytics Users 8 Click Find to locate the group 9 Select the result that was returned for the IT Analytics Users group 10 Click OK 11 Click Apply to save the settings 12 In the Symantec Management Console on the Home menu click ITAnalytics 13 In the left pane right click the IT Analytics folder 14 Select Properties 15 On the Prope...

Page 67: ...he configured pivot table or the pivot chart views as private views Author Private Pivot Views Lets the users save the configured pivot table or the pivot chart views as public views Author Public Pivot Views Lets the users open or load the previously saved pivot table or the pivot chart views that are marked as private Read Private Saved Pivot Views Lets the users open or load the previously save...

Page 68: ...ng access to specific members of a dimension You can restrict access for the IT Analytics Users role to return the cube data only for computers with a Win32 system type For this example you must grant access to the Computer cube for the IT Analytics Users role To filter a role based cube 1 In SQL Server Management Studio in the IT Analytics analysis services database navigate to the properties for...

Page 69: ...tering of the available cube data The delegation features and impersonation features that are available with Windows integrated security can exist across multiple servers In order for this feature to work the network environment in which IT Analytics Solution is installed must be configured to use the Kerberos protocol Without the Kerberos protocol Windows credentials are passed across only one co...

Page 70: ... to configure SQL Server 2004 Analysis Services to use Kerberos authentication at http support microsoft com kb 917409 Configure the reporting services data sources to use stored credentials or prompted credentials to access the analysis services cubes If you use stored credentials all connections from reporting services to analysis services occur in a predefined user context Also role based filte...

Page 71: ...ty IT Analytics Asset Management Pack See IT Analytics Asset Management Pack on page 71 IT Analytics Client and Server Management Pack See IT Analytics Client and Server Management Pack on page 72 IT Analytics Symantec Endpoint Protection Pack See IT Analytics Symantec Endpoint Protection Pack on page 73 IT Analytics ServiceDesk Pack See IT Analytics ServiceDesk Pack on page 74 IT Analytics Asset ...

Page 72: ...rship of Altiris Client Management Suite and Server Management Suite This pack contains all of the core functionality of IT Analytics Solution for the configuration of cubes and reports See About IT Analytics Solution packs on page 71 It also contains the pivot tables and the reports that are associated with the following licensed cubes Add Remove Programs Application Metering Computers ESX Server...

Page 73: ...h configured Symantec Endpoint Protection database It also allows the data to come together into a single unified view of all Symantec Endpoint Protection clients alerts and scan activity Before installing any cubes ensure that the Symantec Endpoint Protection Server is fully configured for each Symantec Endpoint Protection Manager that you want represented in the IT Analytics Symantec Endpoint Pr...

Page 74: ...read data from the ServiceDesk databases Before installing any cubes ensure that the ServiceDesk server is fully configured for the ServiceDesk instance that you want represented in the IT Analytics ServiceDesk cubes This pack contains all of the core functionality of IT Analytics Solution for configuration of cubes and reports The pack also contains all of the pivot tables and reports that are as...

Page 75: ...s Cube IIS Servers Cube Installed Files Cube Installed Software Cube Monitor Metrics Cube Monitor NT Events Cube Monitored Processes Cube Package Distribution Events Cube Package Server Configuration Events Cube Package Server Status Cube Patch Management Cube ServiceDesk Changes Cube ServiceDesk Incidents Cube ServiceDesk Problems Cube A Appendix ...

Page 76: ... Delivery Status Events Cube Software License Compliance Cube Software Purchases Cube SQL Servers Cube Symantec Endpoint Protection Access Rights Symantec Endpoint Protection Alerts Symantec Endpoint Protection Clients Symantec Endpoint Protection Policies Symantec Endpoint Protection Scans Tasks Cube reference 76 ...

Page 77: ...asures Computer Count The distinct number of computers Denial Count The number of times that an application was denied execution File Count The total number of files that matched the given criteria If an application is in multiple locations on the same computer this number can be larger than the Computer Count Run Count The number of times that the application was executed Total Run Time The amoun...

Page 78: ...vides details about the ownership status location and the type of asset that is intended to be used within the organization Dimensions Asset Asset Status Asset Type Cost Center Department Location User Measures Asset Count The number of distinct assets of all types that are in the CMDB Cube reference Assets Cube 78 ...

Page 79: ...isks The results are in Gigabytes Logical Disk Count The count of logical disks This number might be more than one per computer Logical Disk Size GB The sum of the size of logical disks The results are in Gigabytes Physical Memory Capacity GB The sum of the physical memory capacity of the installed memory devices The results are in Gigabytes Physical Memory Device Count The count of physical memor...

Page 80: ...emory arrays for a device support This number is equal to or greater than the actual installed memory device count that is represented in the Physical Memory Device Count measure Processor Speed GHz The maximum speed of a processor for a device or set of devices The results are in gigahertz Processor Count The count of processors for a device or set of devices Cube reference Computers Cube 80 ...

Page 81: ...Servers Dimensions Computer Storage Volume Virtual Machine Measures Host Count The number of machines that host one or more virtual machines Storage Volume Count The number of storage volumes Virtual Machine Count The number of virtual machines by the selected criteria 81 Cube reference ESX Servers Cube ...

Page 82: ...ecurring issues or clients with problems Dimensions Computer Date Event Console Alert Event Console Alert Action Audit Type Event Console Alert Category Event Console Alert Severity Filter Organizational Group Time Measures Action Count The number of actions that were launched Alert Count The number of alerts that were triggered Computer Count The distinct number of computers Cube reference Event ...

Page 83: ...imensions Computer FTP Site Server Virtual Directory Web Site Measures FTP Site Count The distinct number of FTP sites Server Count The number of identified servers Virtual Directory Count The number of virtual directories Web Site Count The number of individual Web sites that were found 83 Cube reference IIS Servers Cube ...

Page 84: ... Symantec Management Platform collects Dimensions Computer File Filter Organizational Group Software Component Software Product Measures Computer Count The distinct number of computers File Count The total number of files that matched the given criteria If a software component is in multiple locations on the same computer this number can be larger than the Computer Count Cube reference Installed F...

Page 85: ... Symantec Management Platform Dimensions Add Remove Programs Computer Filter Organizational Group Software Component Software Product Measures Computer Count The distinct number of computers Instance Count The total number of times that a software component matched the given criteria If a software component is in multiple locations on the same computer this number can be larger than the Computer C...

Page 86: ...ssues on monitored clients Dimensions Computer Date Event Console Alert Event Console Alert Action Audit Type Event Console Alert Category Event Console Alert Severity Event Console Monitor Rule Filter Monitor Metric Monitor Metric Detail Level Monitor Metric Instance Monitor Metric Source Monitor Task Organizational Group Task Server Time Measures Action Count The number of actions that were laun...

Page 87: ... Task Server Computer Count The distinct number of computers This measure group is not valid with the following dimensions Event Console Alert Event Console Alert Action Audit Type Event Console Alert Category Event Console Alert Severity Event Console Monitor Rule Monitor Task Task Server Duration The amount of time in seconds that the given value was in effect for This measure group is not valid...

Page 88: ...Server Metric Count The number of metrics that were recorded This measure group is not valid with the following dimensions Event Console Alert Event Console Alert Action Audit Type Event Console Alert Category Event Console Alert Severity Event Console Monitor Rule Monitor Task Task Server Min The minimum value that was recorded for the given metric This measure group is not valid with the followi...

Page 89: ...ry Event Console Alert Severity Monitor Metric Monitor Metric Detail Level Monitor Metric Instance Monitor Metric Source Avg The average value that was recorded for the given metric This measure group is not valid with the following dimensions Event Console Alert Event Console Alert Action Audit Type Event Console Alert Category Event Console Alert Severity Event Console Monitor Rule Monitor Task ...

Page 90: ...al view of the Windows NT event log of all monitored client computers Dimensions Category Computer Date Description Event ID Filter Log File Message DLL Organizational Group Rule Triggered Source Time Type User Measures Computer Count The distinct number of computers Event Count The number of events Cube reference Monitor NT Events Cube 90 ...

Page 91: ... utilization Max Process CPU Time The maximum CPU time that was used for the given dimension Max Process Handle Count The maximum handle count for the given dimension Max Process Thread Count The maximum number of process threads Max Process Virtual Memory Size The maximum virtual memory size that was consumed in KB for the given dimension Max Process Working Set Size The maximum working set size ...

Page 92: ...e of a CPU for a given process Avg Process CPU Percent Usage The average CPU percent utilization for the given dimension Avg Process CPU Time The average process CPU time for the given dimension Avg Process Handle Count The average process handle count for the given dimension Avg Process Thread Count The average process thread count for the given dimension Avg Process Virtual Memory Size The avera...

Page 93: ...h transfer and the ability to view distribution events over time Dimensions Package Package Distribution Event Date alias for Date Dimension Package Distribution Event Status Package Distribution Event Time alias for Time Dimension Package Server Measures Package Servers The number of package servers that host a package Package Distribution Events The number of distribution events that were sent f...

Page 94: ... each package server and to identify periods of time during which a package server did not communicate with Symantec Management Platform Dimensions Package Server Configuration Request Date alias for Date Dimension Configuration Request Time alias for Time Dimension Measures Configuration Requests The number of configuration requests that were sent between the package servers and Symantec Manageme...

Page 95: ...hat provide clarity into the associations between package servers and packages It also includes the status of each package on each package server Dimensions Package Server Package Package Status Measures Disk Space Used Bytes GB The amount of disk space that is used to host the package Package Servers The number of package servers 95 Cube reference Package Server Status Cube ...

Page 96: ... that meet the requirements for a patch by the given criteria Applicable Patch Count The number of patches that match the given criteria Installed Computer Count The number of computers that have patches installed that match the given criteria Installed Patch Count The number of patches that are installed that match the given criteria Vulnerability Count The number of patches that are required for...

Page 97: ...istorical view of Change Requests in ServiceDesk Dimensions Assigned to User Change Contact Type Date Closed Date Ended Date Implemented Date Opened Date Scheduled Date Started Impact Location Priority Reference Source Status Time Closed Time Ended Time Implemented Time Needed Time Opened Time Scheduled Time Started Type Urgency 97 Cube reference ServiceDesk Changes Cube ...

Page 98: ...the change Open Change Count The number of changes where the status is not a closed state Reference Count The number of references References are items in your environment such as locations departments and assets Avg Age Days The number of days that the change has been opened This number is useful for understanding the age of the change The measure is valid for all changes that do not have a Resol...

Page 99: ...sing the selected criteria Avg Cost To Not Implement The cost to not implement the change This number is averaged across all of the changes using the selected criteria Avg Days to Resolve The number of days it takes to resolve the change Avg Hours to Resolve The number of hours it takes to resolve the change Avg Minutes to Resolve The number of minutes it takes to resolve the change Avg Percent Co...

Page 100: ...cal view of Incidents in ServiceDesk Dimensions Affected User Assigned to User Category Close Code Contact Type Created by User Date Closed Date Modified Date Opened Impact Incident Last Modified by User Location Priority Reference Resolved by User Source Status Time Closed Time Modified Time Opened Type Urgency User Cube reference ServiceDesk Incidents Cube 100 ...

Page 101: ...e the incident was last modified This measure is valid for all incidents that do not have a status of Resolved or Closed Avg Days Spent The average days spent Avg Days To Resolve The average time to resolve in days This measure is valid for all incidents that have a status of Resolved or Closed Avg Hours Since Modified The average number of hours since the incident was last modified This measure i...

Page 102: ...at were escalated one time Escalated Zero Count The number of incidents that were not escalated Exceeded SLA Count The number of incidents that exceeded the defined SLA Exceeded Warn Count The number of incidents that exceeded the Warn time that the SLA defines Incident Count The total number of incidents Closed Incident Count The total number of closed incidents This measure is valid for all inci...

Page 103: ...o a given incident Open Incident Count The total number of open incidents This measure is valid for all incidents that do not have a status of Resolved or Closed Reference Count The number of references A reference can be a number of different associations For example Location Computer and Business Services Reopened Incident Count The number of incidents that have been reopened 103 Cube reference ...

Page 104: ...historical view of Problems that were created in ServiceDesk Dimensions Assigned to User Category Contact Type Date Closed Date Due Date Implemented Date Opened Date Resolved Impact Location Priority Problem Reference Source Status Time Closed Time Due Time Implemented Time Opened Time Resolved Urgency User Cube reference ServiceDesk Problems Cube 104 ...

Page 105: ...ed or Closed state Avg Days Spent The average number of days spent Avg Days To Resolve The number of days to resolve This measure is valid for all problems that have a Resolved or Closed state Avg Hours Spent The average number of hours spent Avg Hours To Resolve The average number of hours to resolve This measure is valid for all problems that have a Resolved or Closed status Avg Minutes Spent Th...

Page 106: ...t values such as Affected User Submitter and Resolution Provider Open Problem Count The total number of open problems This measure is valid for all problems that do not have a Resolved or Closed status Problem Assignment Count The number of users and groups that are assigned to a problem A problem can have more than one person assigned to it Reference Count The number of references A reference can...

Page 107: ...sed Date Ended Date Opened Date Reviewed Date Scheduled Date Started Location Reference Release Status Time Closed Time Ended Time Opened Time Reviewed Time Scheduled Time Started User Measures Avg Age Days The average number of days since the release was created The number is useful for understanding the age of the release This measure is valid for all releases that do not have a Resolved or Clos...

Page 108: ...o Resolve The average number of minutes to resolve This measure is valid for all releases that have a Resolved or Closed status Avg Percent Complete The average percentage that is complete Avg Risk Assessment The average risk assessment score that was given to the releases that make up the selected criteria Missed Scheduled Date Count The number of releases that were not completed by the scheduled...

Page 109: ...different associations For example Location Computer and Business Services Release Assignment Count The number of users and groups that are assigned to a release A release can have more than one person assigned to it 109 Cube reference ServiceDesk Releases Cube ...

Page 110: ...rred over time Dimensions Advertisement alias for Software Delivery Advertisement Event Status alias for Software Delivery Execution Event Status Command Line alias for Software Delivery Execution Event Command Line Computer Event Date alias for Date Dimension Event Time alias for Time Dimension Filter Organizational Group Package Measures Avg Duration In Seconds The average number of seconds that...

Page 111: ...software delivery process Dimensions Computer Download Method alias for Package Download Method Download Source alias for Package Download Source Download URL alias for Package Download URL Event Date alias for Date Dimension Event End Status alias for Software Delivery Package Event Status Event Start Status alias for Software Delivery Package Event Status Event Time alias for Event Time Filter O...

Page 112: ...Total Bytes Transferred The total number of bytes that were transferred during the download of packages Cube reference Software Delivery Package Events Cube 112 ...

Page 113: ...d Dimensions Advertisement alias for Software Delivery Advertisement Computer Event Date alias for Date Dimension Event Status alias for Software Delivery Status Event Status Event Time alias for Time Dimension Event Type alias for Software Delivery Status Event Type Filter Organizational Group Package Measures Events The number of events that the Altiris Agents sent Computer Count The distinct nu...

Page 114: ...h licenses using automated search rules Dimensions Asset Cost Center Department Evaluation Date Location Software License Software Product Measures Installed The number of installed copies of a particular software application In Use The usage count for the software from Application Metering Owned The total number of all software purchases that match the software license Cube reference Software Lic...

Page 115: ...e purchase records within the CMDB and allows the data to be associated with organizational units and software licenses Dimensions Cost Center Date Department Location Software License Software Purchase User Measures Purchase Quantity The total number of all purchases for a particular software application 115 Cube reference Software Purchases Cube ...

Page 116: ...Database Creation Date SQL Database System SQL Storage Area SQL User Measures Cluster Resource Count The number of cluster resources Cluster Count The number of clusters Database System Count The number of database systems Database Count The number of databases Storage Area Count The number of storage areas User Count The number of SQL users Cube reference SQL Servers Cube 116 ...

Page 117: ...ps and computers and the level of access each has Read Full or None Dimensions Administrator Count Computer Rights Group Rights Measures Administrator Count The number of administrators Computer Rights The number of rights that are assigned to computers For a given user a computer can have one of three rights Read Full or No Access Group Rights The number of rights that a group has 117 Cube refere...

Page 118: ...ert Date Computer Domain Group Server Site Virus Measures Alerts The number of alerts that match the given criteria Computers The number of computers that match the given criteria Viruses The number of viruses that match the given criteria Still Infected The number of systems that are still infected that match the given criteria Blocked The number of viruses that were blocked that match the given ...

Page 119: ...number of viruses that were quarantined that match the given criteria Suspicious The number of suspicious viruses that were detected that match the given criteria 119 Cube reference Symantec Endpoint Protection Alerts ...

Page 120: ...ins several important date elements that are meaningful when you manage the deployment and maintenance of Symantec Endpoint Protection clients Dimensions Client Computer Creation Date Domain Group Intrusion Prevention Signature Last Checkin Date Last Scan Date Last Virus Date Server Site Virus Definition Measures Client Count The number of Symantec Endpoint Protection clients that match the given ...

Page 121: ...computers Dimensions Antivirus Policy Application and Control Policy Client Computer Domain Firewall Policy Group IDS Policy Intrusion Protection Signature Last Checkin Date Live Update Policy Server Site Virus Definition Measures Computer Count The number of computers that are subject to the policies Group Count The number of groups 121 Cube reference Symantec Endpoint Protection Policies ...

Page 122: ...rom the scans and the duration of the scans Dimensions Client Computer Domain Group Scan Start Date Server Site Status Measures Computers The total number of computers that were scanned that match the given criteria Duration The total duration to complete a scan that matched the given criteria Infected The total number of infections that were detected that matched the given criteria Omitted The to...

Page 123: ...otal number of threats that were detected that matched the given criteria Total Files The total number of files that were scanned that matched the given criteria 123 Cube reference Symantec Endpoint Protection Scans ...

Page 124: ...r managed client computers performed Dimensions Computer Event Date Event Time Filter Organizational Group Parent Task Task Task End Date Task End Time Task Server Task Start Date Task Start Time Measures Computer Count The distinct number of computers Task Count The distinct number of tasks Cube reference Tasks 124 ...

Page 125: ...hboard Patch Management Dashboard ServiceDesk Change Trend Dashboard ServiceDesk Incident Trend Dashboard ServiceDesk Problem Trend Dashboard ServiceDesk Release Trend Dashboard Software Compliance Dashboard Software Delivery Dashboard Software Installs Dashboard Symantec Endpoint Protection Client Dashboard Symantec Endpoint Protection Risk Dashboard Vista Readiness Dashboard Windows 7 Readiness ...

Page 126: ... operating system manufacturer and domain breakdown of computers It also includes the top five operating systems Event Console Alerts Dashboard Displays a graphical representation of Event Console Alerts by category and severity level It also includes the top event console messages IT Analytics Usage Dashboard Provides a high level summary of IT Analytics usage over time It also includes the top u...

Page 127: ...mpact priority urgency and creator ServiceDesk Problem Trend Dashboard Provides a high level overview of the trends in problem management This dashboard contains the measures that include the average age average hours spent average hours to resolve and average percent complete It also includes the graphs that show the trends for problem volume over time average hours to resolve problems by day of ...

Page 128: ...ashboard Displays a graphical representation of the current Symantec Endpoint Protection clients that are in the environment Specific charts include the client version virus definition version intrusion prevention signatures and the number of days since clients last connected to the Endpoint Protection Manager Symantec Endpoint Protection Risk Dashboard Displays a graphical representation of the t...

Page 129: ...n of memory disk space and processor readiness It also includes a readiness summary and a requirement segmentation summary breakdown of all computers that are based on minimum requirements for Microsoft Windows 7 129 Dashboard reference Windows 7 Readiness Dashboard ...

Page 130: ...Dashboard reference Windows 7 Readiness Dashboard 130 ...

Page 131: ...vent Summary Alert and Task Details Application Metering by File Name Application Metering Search Asset Search Assets by Asset Type Assets by Cost Center Assets by Department Assets by Location Assets by Model Client Version Details Computer Search Computers by CPU Computers by Domain Computers by Manufacturer Computers by Memory C Appendix ...

Page 132: ...re Installs Monitor Alert Details Monitor Metrics CPU Utilization Trend Monitor Metrics Disk Utilization Trend Monitor Metrics Network Utilization Trend Monitor Metrics Trend Monitored Processes CPU Utilization Trend Package Download Event Summary Package Server Availability Monthly Package Server Availability Daily Patch Management Bulletin Summary Patch Management Details Patch Vulnerability Pat...

Page 133: ...ority ServiceDesk Incidents by Status ServiceDesk Incidents by Type ServiceDesk Incidents by Urgency ServiceDesk Problem Search ServiceDesk Problems by Assigned to User ServiceDesk Problems by Category ServiceDesk Problems by Impact ServiceDesk Problems by Priority ServiceDesk Problems by Status ServiceDesk Problems by Urgency ServiceDesk Release Search ServiceDesk Releases by Assigned to User Ser...

Page 134: ...s report lets users define a publisher and a program name to filter the results with Add Remove Programs Search Displays the publisher program name and computer name for each distinct program and computer that the Altiris Software Management Framework detected in the Add Remove Programs registry This report lets users define a publisher and a program name to filter the results with Advertisement E...

Page 135: ...e report lets users define a month and a year date range file name and product name to filter the results with Asset Search Displays the asset name serial number system number asset type asset status cost center department location manufacturer model and owner The report lets users filter the results by any of these fields Assets by Asset Type Displays the asset type along with counts of each asse...

Page 136: ...anufacturer along with counts of each asset status The report lets users filter the results by asset type asset status department cost center and location Client Version Details Displays the details of the Symantec Endpoint Protection client versions that are in the environment Computer Search Displays a summary of computer hardware and OS inventory as detected by Inventory Solution The report all...

Page 137: ...major informational normal undetermined and by value alerts over time These counts are displayed in table format along with a graphical trend of alerts for a designated period of time Installed Files by File Name Displays the file name product name and manufacturer It also includes a count of computers where software exists as detected by Altiris Software Management Framework The report lets users...

Page 138: ...e results by month day year event type event target and event descriptions IT Analytics Usage Events Provides a historical view of the report and cube utilization from IT Analytics Solution The report lets users filter the results by a month day year action source patch and user Microsoft Server Applications Displays the number of computers that have Microsoft server applications Microsoft Softwar...

Page 139: ...r This report includes a table that details the network utilization metrics Monitor Metrics Trend Displays a graphical representation of Monitor Alerts and Tasks Monitored Processes CPU Utilization Trend Displays a graphical representation of the utilization of the CPU over time for the monitored client This report includes a table that details the CPU utilization metrics for the CPU Package Downl...

Page 140: ...ily Displays the information that is contained in the Package Server Configuration Event cube It shows the percentage of time that the package servers communicated with Symantec Management Platform The time is measured by comparing the expected number of configuration requests from a package server to the actual number of configuration requests that the package server performed over time The repor...

Page 141: ...unt of computers scans threats and the total files that were scanned over time in a table form It also includes a graphical trend of computers scans and threats for a designated period of time Servers by Type and Version Displays a count of the computers that are running a server OS and displays these computers by OS title and version ServiceDesk Change Search Displays a summary of change informat...

Page 142: ...tatus with a breakdown by year quarter and month The report lets users filter the results by a date range type impact priority urgency and assignee ServiceDesk Changes by Type Displays a count of changes by type with a breakdown by year quarter and month The report lets users filter the results by a date range type impact priority urgency and assignee ServiceDesk Changes by Urgency Displays a coun...

Page 143: ...tor and assignee ServiceDesk Incidents by Impact Displays a count of incidents by impact with a breakdown by year quarter and month The report lets users filter the results by a month and year date range type category impact priority urgency creator and assignee ServiceDesk Incidents by Priority Displays a count of incidents by priority with a breakdown by year quarter and month The report lets us...

Page 144: ... of problem information The report lets users filter the results by a date range category impact priority urgency and assignee ServiceDesk Problems by Assigned to User Displays a count of problems by worker with a breakdown by year quarter and month The report lets users filter the results by a date range category impact priority urgency and assignee ServiceDesk Problems by Category Displays a cou...

Page 145: ...mpact priority urgency and assignee ServiceDesk Problems by Urgency Displays a count of problems by urgency with a breakdown by year quarter and month The report lets users filter the results by a date range category impact priority urgency and assignee ServiceDesk Release Search Displays a summary of release information The report lets users filter the results by a month a year date range type ca...

Page 146: ...ventory classes and not from the original events Software License Compliance by Cost Center Displays the license name by cost center It also contains a count of installed used owned and compliance status The report lets users filter the results by license name month and year cost center department and location Software License Compliance by Department Displays the license name by department It als...

Page 147: ...hical representation of the top Windows processes that use the greatest amount of virtual memory for a given monitored client computer This report includes a table that details the hourly virtual memory utilization Top 10 Users Consuming CPU Displays a graphical representation of the top owners of Windows processes that are consuming the greatest amount of CPU for a given monitored client computer...

Page 148: ...ed on the minimum requirements for Microsoft Vista The report lets users filter the results by computer name manufacturer and model Windows 7 Readiness Details Displays a summary of computer hardware and OS inventory as detected by Inventory Solution This report contains the parameters that let you filter the results that are based on the minimum requirements for Microsoft Windows 7 This report le...

Page 149: ...e following topics Add Remove Programs Asset Asset Status Asset Type Computer Cost Center Created Date Date Department EP Access Right EP Administrator EP Alert EP Alert Date EP AntiVirus Policy EP Application and Device Control Policy EP Client D Appendix ...

Page 150: ... Virus Date EP Live Update Policy EP Scan EP Scan Client User EP Scan Start Date EP Scan Status EP Server EP Site EP Virus EP Virus Definition ESX Storage Volume ESX Virtual Machine Event Console Alert Event Console Alert Action Audit Type Event Console Alert Category Event Console Alert Severity Event Console Monitor Rule File Dimension Attribute reference 150 ...

Page 151: ...tric Source Monitor NT Event Category Monitor NT Event Description Monitor NT Event ID Monitor NT Event Log File Monitor NT Event Message DLL Monitor NT Event Rule Triggered Monitor NT Event Source Monitor NT Event Type Monitor NT Event User Monitor Process Name Monitor Process Owner Monitor Task Organizational Group Package Package Distribution Event Status 151 Dimension Attribute reference ...

Page 152: ...sk Change Location ServiceDesk Change Priority ServiceDesk Change Source ServiceDesk Change Status ServiceDesk Change Type ServiceDesk Change Urgency ServiceDesk Contact Type ServiceDesk Created by User ServiceDesk Date Closed ServiceDesk Date Due ServiceDesk Date Ended ServiceDesk Date Implemented ServiceDesk Date Modified ServiceDesk Date Needed ServiceDesk Date Opened ServiceDesk Date Resolved ...

Page 153: ...Desk Incident Status ServiceDesk Incident Type ServiceDesk Incident Urgency ServiceDesk Last Modified by User ServiceDesk Problem ServiceDesk Problem Category ServiceDesk Problem Impact ServiceDesk Problem Location ServiceDesk Problem Priority ServiceDesk Problem Source ServiceDesk Problem Status ServiceDesk Problem Urgency ServiceDesk Reference ServiceDesk Release ServiceDesk Release Location Ser...

Page 154: ...esk Time Started ServiceDesk User Software Component Software Delivery Advertisement Software Delivery Execution Event Command Line Software Delivery Execution Event Status Software Delivery Package Event Status Software Delivery Status Event Status Software Delivery Status Event Type Software License Software Product Software Purchase Software Update SQL Cluster SQL Cluster Resource SQL Database ...

Page 155: ... Remove Programs Display Name Add Remove Programs Hidden Asset Asset contains the following dimension attributes Asset Asset Tag Asset Barcode Asset Manufacturer Asset Model Asset Name Asset Resource Guide Asset Serial Number Asset Status Asset Status contains the following dimension attributes Asset Status 155 Dimension Attribute reference Add Remove Programs ...

Page 156: ...puter Last Logon User Computer MAC Address Computer Manufacturer Computer Model Computer Name Computer OS Name Computer OS Type Computer OS Version Computer OS Revision Computer Primary User Computer Resource Guide Computer Serial Number Computer Server Computer System Type Cost Center Cost Center contains the following dimension attributes Cost Center Code Cost Center Hierarchy Path Dimension Att...

Page 157: ...ed Date Year Date Date contains the following dimension attributes Date Day of Week Month Quarter Year Department Department contains the following dimension attributes Department Hierarchy Level Department Hierarchy Path Department Name EP Access Right EP Access Right contains the following dimension attributes Access Right Type 157 Dimension Attribute reference Created Date ...

Page 158: ...Administrator User Name EP Alert EP Alert contains the following dimension attributes Alert Actual Action Alert File Path Alert Requested Action Alert Secondary Action Alert Source Alert User Name Alert Virus Type EP Alert Date EP Alert Date contains the following dimension attributes Alert Date Date Alert Date Day of Week Alert Date Quarter Alert Date Month Alert Date Year Dimension Attribute ref...

Page 159: ...remental Scan Interval AntiVirus Policy Internet Email Auto Protect AntiVirus Policy Lock Back Up File Before Repair AntiVirus Policy Lock Block Security Risk Install AntiVirus Policy Lock Enable Floppy Drive AntiVirus Policy Lock Enable Network Drive AntiVirus Policy Lock File System Auto Protect AntiVirus Policy Lock File Types AntiVirus Policy Lock Incremental Scan Interval AntiVirus Policy Loc...

Page 160: ... Run Scan On Login AntiVirus Policy Scan All Files AntiVirus Policy Scan For Keyloggers AntiVirus Policy Scan For Trojans And Worms AntiVirus Policy Scan New Processes AntiVirus Policy Scan Security Risks AntiVirus Policy Security Risks First Action AntiVirus Policy Security Risks Second Action AntiVirus Policy Stop Services Automatically AntiVirus Policy Terminate Processes Automatically AntiViru...

Page 161: ...Disk Client Free Memory Client Host Integrity Status Client Infected Client Major Version Client Minor Version Client Online Status Client Profile Serial Number Client Profile Version Client Reboot Required Client Tamper Protection Status Client Time Zone EP Computer EP Computer contains the following dimension attributes Computer BIOS Version Computer Computer Name Computer Current Login Domain C...

Page 162: ... Computer Processor Count Computer Processor Type Computer Service Pack Computer TPM Device Computer WINS Server EP Creation Date EP Creation Date contains the following dimension attributes Creation Date Date Creation Date Day of Week Creation Date Month Creation Date Quarter Creation Date Year EP Domain EP Domain contains the following dimension attributes Domain Dimension Attribute reference EP...

Page 163: ...y Smart DNS Firewall Policy Smart WINS Firewall Policy Stealth Mode Browsing Firewall Policy TCP Resequencing Firewall Policy Token Ring Traffic EP Group EP Group contains the following dimension attributes Group EP IDS Policy EP IDS Policy contains the following dimension attributes IDS Policy Active Response Block IP IDS Policy Denial Of Service Protection IDS Policy Enabled IDS Policy Intrusion...

Page 164: ...tes Last Checkin Date Date Last Checkin Date Day of Week Last Checkin Date Month Last Checkin Date Quarter Last Checkin Date Year EP Last Scan Date EP Last Scan Date contains the following dimension attributes Last Scan Date Date Last Scan Date Day of Week Last Scan Date Month Last Scan Date Quarter Last Scan Date Year EP Last Virus Date EP Last Virus Date contains the following dimension attribut...

Page 165: ...ule Download Frequency Interval Live Update Policy Schedule Download Randomization Live Update Policy Schedule Download Randomization Time Live Update Policy Schedule Download Retry Live Update Policy Schedule Download Retry Window Live Update Policy Schedule Download Start Time Live Update Policy Schedule Enabled EP Scan EP Scan contains the following dimension attributes Scan Client User Scan ID...

Page 166: ...EP Scan Status contains the following dimension attributes Scan Status EP Server EP Server contains the following dimension attributes Server EP Site EP Site contains the following dimension attributes Site EP Virus EP Virus contains the following dimension attributes Virus Date Discovered Virus Name Virus Risk Category Virus Threat Location Virus Threat Type Dimension Attribute reference EP Scan ...

Page 167: ... Storage Volume Instance ID ESX Storage Volume Total Size GB ESX Storage Volume Volume Name ESX Virtual Machine ESX Virtual Machine contains the following dimension attributes ESX Virtual Machine Automatic Shutdown Action ESX Virtual Machine Automatic Shutdown Delay ESX Virtual Machine Automatic Startup Action ESX Virtual Machine Automatic Startup Delay ESX Virtual Machine CPS Assigned ESX Virtual...

Page 168: ...rt Action Audit Type Action Type Name Event Console Alert Category Event Console Alert Category contains the following dimension attributes Event Console Alert Category Name Event Console Alert Severity Event Console Alert Severity contains the following dimension attributes Event Console Alert Severity Severity Level Event Console Alert Severity Severity Name Event Console Monitor Rule Event Cons...

Page 169: ...the following dimension attributes IIS Server Application Server Console Installed IIS Server ASP Dot Net Installed IIS Server ASP Installed IIS Server BITS Service IIS Server COM Plus Service IIS Server Instance ID IIS Server Internet Data Connector Installed IIS Server Message Queue Service IIS Server Network DTC Installed IIS Server NNTP Service IIS Server Remote Admin Installed IIS Server Remo...

Page 170: ...IS Virtual Directory Content Location IIS Virtual Directory Content Location Path IIS Virtual Directory Default Document Name IIS Virtual Directory Default Document Enabled IIS Virtual Directory Digest Authentication Enabled IIS Virtual Directory Directory Browsing Enabled IIS Virtual Directory Dot Net Passport Authentication Enabled IIS Virtual Directory Element Name IIS Virtual Directory Execute...

Page 171: ...IIS Web Site Certificate Enabled IIS Web Site Connection Limit IIS Web Site Content Expiration Enabled IIS Web Site Content Expiration Setting IIS Web Site Content Location IIS Web Site Default Document Name IIS Web Site Default Document Enabled IIS Web Site Digest Authentication Enabled IIS Web Site Directory Browsing Enabled IIS Web Site Dot Net Passport Authentication Enabled IIS Web Site Enfor...

Page 172: ...e Date Last Basic Inventory Date Day of Week Last Basic Inventory Date Month Last Basic Inventory Date Quarter Last Basic Inventory Date Year Location Location contains the following dimension attributes Location Address Location City Location Country Location Name Location State Location Zip Logical Disk Logical Disk contains the following dimension attributes Logical Disk Description Logical Dis...

Page 173: ...itor Metric Instance Instance Name Monitor Metric Source Monitor Metric Source contains the following dimension attributes Monitor Metric Source Source Name Monitor NT Event Category Monitor NT Event Category contains the following dimension attributes Monitor NT Event Category Monitor NT Event Description Monitor NT Event Description contains the following dimension attributes Monitor NT Event De...

Page 174: ... attributes Monitor NT Event Rule Triggered Monitor NT Event Source Monitor NT Event Source contains the following dimension attributes Monitor NT Event Source Monitor NT Event Type Monitor NT Event Type contains the following dimension attributes Monitor NT Event Type Monitor NT Event User Monitor NT Event User contains the following dimension attributes Monitor NT Event User Monitor Process Name...

Page 175: ...ackage contains the following dimension attributes Package Name Package Distribution Event Status Package Distribution Event Status contains the following dimension attributes Package Distribution Event Status Package Download Method Package Download Method contains the following dimension attributes Package Download Method Package Download Source Package Download Source contains the following dim...

Page 176: ... dimension attributes Package Status Parent Task Parent Task contains the following dimension attributes Parent Task Instance Type Parent Task Name Processor Processor contains the following dimension attributes Processor Description Processor Manufacturer Processor Model Processor Number of Processors Processor Speed GHz ServiceDesk Affected User ServiceDesk Affected User contains the following d...

Page 177: ... ServiceDesk Assigned to User ServiceDesk Assigned to User contains the following dimension attributes Assigned to User Address1 Assigned to User Address2 Assigned to User City Assigned to User Department Assigned to User Display Name Assigned to User First Name Assigned to User Last Name Assigned to User Organizational Title Assigned to User Primary Email Assigned to User State Assigned to User V...

Page 178: ...ired Change Verified ServiceDesk Change Impact ServiceDesk Change Impact contains the following dimension attributes Change Impact ServiceDesk Change Location ServiceDesk Change Location contains the following dimension attributes Change Location ServiceDesk Change Priority ServiceDesk Change Priority contains the following dimension attributes Change Priority ServiceDesk Change Source ServiceDesk...

Page 179: ...Change Urgency ServiceDesk Contact Type ServiceDesk Contact Type contains the following dimension attributes Contact Type ServiceDesk Created by User ServiceDesk Created by User contains the following dimension attributes Created by User Address1 Created by User Address2 Created by User City Created by User Department Created by User Display Name Created by User First Name Created by User Last Nam...

Page 180: ...uarter Date Closed Year ServiceDesk Date Due ServiceDesk Date Due contains the following dimension attributes Date Due Date Date Due Day of Week Date Due Month Date Due Quarter Date Due Year ServiceDesk Date Ended ServiceDesk Date Ended contains the following dimension attributes Date Ended Date Date Ended Day of Week Date Ended Month Date Ended Quarter Date Ended Year Dimension Attribute referenc...

Page 181: ...ibutes Date Modified Date Date Modified Day of Week Date Modified Month Date Modified Quarter Date Modified Year ServiceDesk Date Needed ServiceDesk Date Needed contains the following dimension attributes Date Needed Date Date Needed Day of Week Date Needed Month Date Needed Quarter Date Needed Year ServiceDesk Date Opened ServiceDesk Date Opened contains the following dimension attributes Date Op...

Page 182: ...the following dimension attributes Date Reviewed Date Date Reviewed Day of Week Date Reviewed Month Date Reviewed Quarter Date Reviewed Year ServiceDesk Date Scheduled ServiceDesk Date Scheduled contains the following dimension attributes Date Scheduled Date Date Scheduled Day of Week Date Scheduled Month Date Scheduled Quarter Date Scheduled Year ServiceDesk Date Started ServiceDesk Date Started ...

Page 183: ...ce Incident Escalated Once Incident Exceeded SLA Incident Exceeded Warn Incident ID Incident Name Incident URL Incident Resolved On First Attempt Incident Survey Present ServiceDesk Incident Category ServiceDesk Incident Category contains the following dimension attributes Incident Category ServiceDesk Incident Close Code ServiceDesk Incident Close Code contains the following dimension attributes ...

Page 184: ...s Incident Priority ServiceDesk Incident Source ServiceDesk Incident Source contains the following dimension attributes Incident Source ServiceDesk Incident Status ServiceDesk Incident Status contains the following dimension attributes Incident Status ServiceDesk Incident Type ServiceDesk Incident Type contains the following dimension attributes Incident Type ServiceDesk Incident Urgency ServiceDe...

Page 185: ... by User Organizational Title Last Modified by User Primary Email Last Modified by User State Last Modified by User VIP Last Modified by User Zip ServiceDesk Problem ServiceDesk Problem contains the following dimension attributes Problem Action To Date Problem Exceeded SLA Problem Exceeded Warn Problem ID Problem Next Step Problem Resolved Problem RFC Problem Title Problem URL ServiceDesk Problem ...

Page 186: ... attributes Problem Priority ServiceDesk Problem Source ServiceDesk Problem Source contains the following dimension attributes Problem Source ServiceDesk Problem Status ServiceDesk Problem Status contains the following dimension attributes Problem Status ServiceDesk Problem Urgency ServiceDesk Problem Urgency contains the following dimension attributes Problem Urgency ServiceDesk Reference Service...

Page 187: ...RL ServiceDesk Release Location ServiceDesk Release Location contains the following dimension attributes Release Location ServiceDesk Release Status ServiceDesk Release Status contains the following dimension attributes Release Status ServiceDesk Resolved by User ServiceDesk Resolved by User contains the following dimension attributes Resolved by User Address1 Resolved by User Address2 Resolved by...

Page 188: ...ains the following dimension attributes Time Closed Hour Time Closed Minute Time Closed Second Time Closed Time ServiceDesk Time Due ServiceDesk Time Due contains the following dimension attributes Time Due Hour Time Due Minute Time Due Second Time Due Time ServiceDesk Time Ended ServiceDesk Time Ended contains the following dimension attributes Time Ended Hour Time Ended Minute Time Ended Second ...

Page 189: ...attributes Time Modified Hour Time Modified Minute Time Modified Second Time Modified Time ServiceDesk Time Needed ServiceDesk Time Needed contains the following dimension attributes Time Needed Hour Time Needed Minute Time Needed Second Time Needed Time ServiceDesk Time Opened ServiceDesk Time Opened contains the following dimension attributes Time Opened Hour Time Opened Minute Time Opened Secon...

Page 190: ...ewed Hour Time Reviewed Minute Time Reviewed Second Time Reviewed Time ServiceDesk Time Scheduled ServiceDesk Time Scheduled contains the following dimension attributes Time Scheduled Hour Time Scheduled Minute Time Scheduled Second Time Scheduled Time ServiceDesk Time Started ServiceDesk Time Started contains the following dimension attributes Time Started Hour Time Started Minute Time Started Se...

Page 191: ...ip Software Component Software Component contains the following dimension attributes Software Component Company Name Software Component Name Software Component Software Product Name Software Component Software Type Name Software Component Type Name Software Component Version Software Delivery Advertisement Software Delivery Advertisement contains the following dimension attributes Advertisement Na...

Page 192: ...tains the following dimension attributes Event Status Software Delivery Status Event Status Software Delivery Status Event Status contains the following dimension attributes Event Status Software Delivery Status Event Type Software Delivery Status Event Type contains the following dimension attributes Event Type Software License Software License contains the following dimension attributes Software...

Page 193: ...rence Software Update Severity SQL Cluster SQL Cluster contains the following dimension attributes SQL Cluster Cluster Name SQL Cluster IP Address SQL Cluster Max Number of Nodes SQL Cluster Total Number of Nodes SQL Cluster Resource SQL Cluster Resource contains the following dimension attributes SQL Cluster Resource Instance Name SQL Cluster Resource IP Address SQL Cluster Resource Owner Node SQ...

Page 194: ...se Size Allocated MB SQL Database Space Available MB SQL Database Creation Date SQL Database Creation Date contains the following dimension attributes Database Creation Date Date Database Creation Date Day of Week Database Creation Date Month Database Creation Date Quarter Database Creation Date Year SQL Database System SQL Database System contains the following dimension attributes SQL Database S...

Page 195: ...Area contains the following dimension attributes SQL Storage Area File System Size GB SQL Storage Area File System Type SQL Storage Area Name SQL User SQL User contains the following dimension attributes SQL User Name Task Task contains the following dimension attributes Task Name Task Return Code Task Success Task Server Task Server contains the following dimension attributes Task Server Name 195...

Page 196: ...User contains the following dimension attributes User City User Company User Country User Display Name User Domain User Email User Given Name User Job Title User Office Location User State User Street Address User Surname User User Name User Zip Dimension Attribute reference Time 196 ...

Page 197: ...ents 90 cube continued monitor processes 91 package distribution events 93 package server configuration events 94 package server status 95 patch management 96 ServiceDesk Changes 97 ServiceDesk Incidents 100 ServiceDesk problems 104 ServiceDesk releases 107 software delivery execution events 110 software delivery package events 111 software delivery status events 113 software license compliance 11...

Page 198: ...ack Asset Management 71 Client and Server Management 72 pack continued removing 31 Symantec Endpoint Protection 73 74 pivot chart displaying results 48 pivot charts toolbar functions 45 pivot data displaying results 48 pivot table deleting a view 47 displaying results 49 exporting results 49 fields 43 loading a view 46 modifying a view 46 overview 42 prerequisites 42 saving a view 45 toolbar funct...

Page 199: ...U uninstallation IT Analytics 31 199 Index ...

Search results

Summary of Contents for ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0

Reviews:

Related manuals for ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0

Brands by name

Popular brands

Symantec ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0, Manual

Search results

Summary of Contents for ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0

Reviews:

Related manuals for ALTIRIS CLIENT MANAGEMENT SUITE 7.0 SP2 - V1.0

Brands by name

Popular brands