Home

User Manual

1. By Field RoleName Pattern Role Role Description Organization Owner Resources ADMGNRL IT 10 ADMHR IT 2 4 ADMNMGR IT 0 2 ADMNS IT O 4 ADMPUR IT 2 4 APPLDEV IT 3 6 B5AVEJ1 IT SageBank 10 3 B ELAN IT SageBank D 1 BSAVEMGR Role IT 2 3 Role IT d 2 e Role IT 0 1 BALLI1 Role IT 0 D BALLLAN Role BALI 0 BASIC ROLE 66 2 BRLIM 3 3 BRTSJ1 1 3 BSILVJ1 3 3 0 L BSILVMGR 2 3 BSILVSPRIV 1 2 BSILVSYS 1 BSTAMJ1 5 3 D 1 1 4 ib 2 0 1 CAYMAN People working in GEO 0 Cayman DBA New Org 3 5 DBAGNRL IT 2 3 DBAMGR IT 1 D DBAUNIX IT 2 3 Development New Org 4 td DEv MF IT SageBank 4 5 DEV PC IT SageBank 2 4 DEV UX IT SageBank 3 2 FINAP IT 2 3 FINAR IT 2 3 Client L M len ogo Page 1 of 3 eurekify Sage biscovery amp Audit Sage Discovery amp Audit Figure 25 Configuration Roles Report Page 26 Version 3 1 Eurekify 2 1 10 Configuration Roles Detailed Report General Lists some all of a configuration s roles including ALL the roles fields and counters Version 3 1 Parameters Configuration By Field Which role field to choose users by From To Choose a range of values or leave empty for all Pattern Show only role that match a pattern Config ConfigV From Role ID Role Name ADMGNRL OTT mee Sage Role Role Organization 1T Role Owner SageBank Role Type Role Counters Direct Users Indirect Users
2. eese 79 CHAPTER 3 SUBSCRIBING TO REPORTS ese see sesse see sesse see sesse see se sees 81 34 General OVerVIeW iain eae pte ate e e ei sis eee 81 EN GR EE Ser ER cele tete EE 81 SageReports Page iv Version 3 1 List of Figures FIGURE 1 FIGURE 2 FIGURE 3 FIGURE 4 FIGURE 5 FIGURE 6 FIGURE 7 FIGURE 8 FIGURE 9 FIGURE 10 FIGURE 11 FIGURE 12 FIGURE 13 FIGURE 14 FIGURE 15 FIGURE 16 FIGURE 17 FIGURE 18 FIGURE 19 FIGURE 20 FIGURE 21 FIGURE 22 FIGURE 23 FIGURE 24 FIGURE 25 FIGURE 26 FIGURE 27 FIGURE 28 FIGURE 29 FIGURE 30 FIGURE 31 FIGURE 32 FIGURE 33 FIGURE 34 FIGURE 35 FIGURE 36 FIGURE 37 FIGURE 38 FIGURE 39 FIGURE 40 FIGURE 41 FIGURE 42 FIGURE 43 FIGURE 44 FIGURE 45 FIGURE 46 FIGURE 47 FIGURE 48 FIGURE 49 FIGURE 50 FIGURE 51 FIGURE 52 Version 3 1 REPORTING SERVICES aaa aa INSTALLATION SETTINGS SELECT THE NSTALLATION FOLDER CONFIRM INSTALLATION iss 3 sa SP oa ee aida sita iris ds sko Peta st see SAGE REPORTS HOME PAGE iiiisss a SAGE REPORTS a aaa SAGE PORTAL HOME PAGE aaaa aa EIST OE REPORTS coe eo erre testet eee esse Qe Re eua eita EMPTY REPORTS WINDOW airea esse E ee Re A ee REPORTS WINDOW SHOWING A GENERATED REPORT REPORTS WINDOW FROM WITH SAGE PORTAL CLIENT APPLICATION 10 GENERATING REPORTS 55 44 113540 oe ee test etae Ea E cusp es ed aaa Nee is NAVIGATION BETWEEN FOLDERS SDB CONNECTION STRING OPTIONS EX
3. 2 1 5 Configuration Users Full Report General Lists some all of a configuration s users including each user s roles and resources Parameters Configuration By Field which user field to chose users by From To Choose a range of values or leave empty for all Pattern Show only users who match a pattern Configuration Users Full Report 25 10 2005 12 48 Config ConfigWIthRoles3 By Field Organization From Application To Application Pattern Sort Ascending User 57644540 Alex Patrick Person ID 57644540 User Name Alex Patrick Organization Application Development Organization Type Corporate Country Us Location Pennsylvania Title Developer Cost Center 30111 Direct Resources None Dual Resources Resources count 6 Res name 1 Res name 2 Res name 3 Owner Organization DEVELOP RACFPROD RACF22 MYSPROD Production RACF DEVELOP RACFTEST RACF22 MVSTEST Test RACF ITESTDEV RACFPROD RACF22 MYSPROD Production RACF ITESTDEV RACFTEST RACF22 MYSTEST Test RACF e mail outlook WinNT loffice2003 2003 WinNT Indirect Resources Resources count 1 Res name 1 Res name 2 Res name 3 Owner Organization UGAPPLDEV Administr NOVELADM Novell4 ADMNLAN ation ROOT Direct Roles Roles count 4 ID Role Name Description Organization Owner BASIC ROLE New Role Organization Application Characteristic Role 8096 Development Development New Role Iterated New Org New O
4. Dual Users Total Users Role ID Role Name Role Description Role Organization Role Owner Role Type Role Counters Direct Users Indirect Users Dual Users Total Users Role ID Role Name Role Description Role Organization Role Owner Role Type Role Counters Direct Users Indirect Users Dual Users Total Users Configuration Roles Detailed Report By Field yJleN me Patt Role Create Date Role Reviewer 26 10 2005 12 53 Role Approve Code Role Approved Date Role Organization2 Role Organization3 Direct Par Roles Indirect Par Roles Dual Par Roles Total Par Roles Role Create Date Role Reviewer Direct Sub Roles Indirect Sub Roles Dual Sub Roles Total Sub Roles Role Approve Code Role Approved Date Role Organization2 Role Organization3 Direct Par Roles Indirect Par Roles Dual Par Roles Total Par Roles Role Create Date Role Reviewer rect Sub Roles ect Sub Roles Dual Sub Roles Total Sub Roles Role Approve Code Role Approved Date Direct Par Roles Indirect P r Roles Dual Par Roles Total Par Roles Direct Sub Roles Indirect Sub Roles Dual Sub Roles Total Sub Roles Client Logo Page 1 of 32 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 26 Configuration Roles Detailed Report SageReports Page 27 Eurekify 2 1 11 General Lists some all of a configuration s roles inc
5. Config ConfigWIthRoles3 By Field RoleOrganization From New Org To New Org Sort Ascending RoleOrganization New Org Status Approved UGSTAMSYS New Role Iterated Approved UGSILVSYS New Role Iterated Approved Status Pending bere marin Mias Pal FA ska iN Die die m Total Roles for New Org 16 07 12 2005 Roles Approval Status Report 06 27 Role Create Date Approved Approve D te Description Status UGSILVLAN New Role Iterated Approved pi RL RO OR SS m a n3 e VESYS New Role Iterated Approved n3 no a Oja Op U ya NA Nj M Set LE o SS 121 na n3 n3 n3 a es with Status Approved Role Role Create Date Approved Approve D te Name Description Status 40 3 tana HE Approved ES Pending EHI Denied OO Pre approved Version 3 1 Figure 53 Roles Approval Status Report Page 67 Eurekify SageReports 2 5 3 Users Role Base Privileges General Filters the selected configuration based on the selected field and displays the the role based resources for each Users identified by the filter Parameters Configuration By Field Filter the configuration for a User s role based privileges based on the selected field From To range Pattern EC 1 9 12 2006 3 07 Users Role Based Privileges Report iid Config Config WithRoles From Branch Manager To Branch Manager Fifth Ave Branch Organization Type Branches Br
6. Zh Report Manager Microsoft Internet Explorer Eee ay G sak A A GO P see Vrot R m a Address http localhost Reports Pages Report aspx 7ItemPath 2FSageReports 2FConfigurati v EJ co Links 4 amp Report Manager Reporting Services Google C search GO s Brzblocked ABF Check gt SQL Server Reporting Home My Subscriptions Services Site Settings Help Home gt SageReports gt 1 Configuration Reports gt Search for Ge 01 Configuration Properties Report Properties p tory Subscriptions E E New Subscription ES Te neni View Report 4 Jofi Pi 100 wj Find Next a Select a format Export A 3 21 Configuration Properties Repe Configuration Config WIthRoles3 3 Local intranet Page 84 Version 3 1 Eurekify To subscribe to a report SageReports 1 Go to the report to which you want to subscribe 1 Click on the New Subscription button 2 Choose the delivery method If email is chosen fill in the necessary fields To From and so on for the message 3 Choose the file format for example pdf or excel Please review the diagram EEK View Favorites Tools Help ay E Report Manager Microsoft Internet Explorer File Edit Q sex dd x 2 EA Je Search sip Favorites Address e http localhost Reports Pages SubscriptionProperties YW Go Links amp amp Report Manager Reporting S
7. roles and resources in addition to various data from AuditCard proposed new roles proposed new resources and almost matching roles In addition the report groups the users by a chosen user category for instance location and presents group statistics for each value in the category Parameters Configuration User Category From To choose range Pattern Show Roles Resources Whether to show each user s roles and resources Show group roles resources Whether to show each group s roles and resources AuditCard Show alerts from AuditCard Prerequisites AuditCard which has the following alerts selected Tab In Out of pattern entities check all the boxes Page 71 Eurekify SageReports Users Certification Report by Category 26 10 2005 04 26 Config ConfigWIthRoles3 By Field Location From Cayman To Cayman Pattern Sort Ascending Location Cayman User 89753140 Cherry Jay Person ID 89753140 User Name Cherry Jay Organization Finance Organization Type Corporate Country Location Cayman Cost Genter 25777 11234 Resources Info Roles Info User 91724340 Hope Collin 91724340 User Name Hope Collin Organization Finance Organiz tion Type Corporate Country US Location Cayman Title Accountant Cost Center 28777 Resources Info Roles Info User 97774230 More Cathrine Person ID 97774230 User Name More Cathrine Organization Finance Organization Type Corporate Cou
8. 97 92 1 04 1 04 Top 10 Suspects RoleID Role Name Description Organization Score 1001 BASIC ROLE New Role 2322 1150 ADMGNRL Sage Role IT 565 Page 1 of 1 eureify Sage Discovery amp Audit Sage Discovery amp Audit Figure 44 Suspected Role Definitions Page 50 Version 3 1 Eurekify SageReports 2 4 8 Suspected Connections User Resource General This report keeps track of the suspected user resource connections that appear in the given AuditCard including how many alerts are there in each severity based on the alert s score with a pie chart and a list of the top 10 suspected connections Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes User Resource Connections Version 3 1 Page 51 Eurekify SageReports Suspected Connections User Resource Config ConfigwIthRoles3 AuditCard ConfigWIthRoles3Audit1 Connections yi Total Alerts in AuditCard Very Low Under 29 Total User Res Connections Total Users 67 Total Resources 83 92 6 3 2 2 8 1 2 0 2 Top 10 Suspected Connections User Resource Alert PersonID User Name Res Name 1 Res Name 2 Res Name 3 Score 87368000 Toper Jim UGSAVEGEN NT5AVE WinNT 44 98383830 Capel Linda TESTDEV RACFPROD RACF22 36 98383830 Capel Linda TESTDEV
9. BPR Role Role lt L gt Only Allowed to Have lt R gt Finance Cayman People in Cayman are only allowed to these Onsite 1 roles BPR Role Role lt L gt Must Have lt R gt Finance Cayman People in Cayman must be in this role Onsite 2 BPR Role Role lt L gt Forbidden to Have lt R gt Finance Cayman This is not consistent with previous assertions Onsite 4 BPR Role Resource Only lt L gt May Have lt R gt Role Mar 1 Just a test of role resource restriction BPR Role Resource lt L gt Forbidden to Have lt R gt Role Mar 3 role resource 3 BPR Role Resource lt L gt Only Allowed to Have lt R gt Role Mar 4 role resource 4 BPR Segregation of Duty Resources Exactly Res Seg 1 Segregation of Duty on Resources BPR Resource Resource lt L gt Forbidden to Have lt R gt Test vs Prod You cannot use production from your test account BPR User Attribute Role Only lt L gt May Have lt R gt Fifth ave Only people from Fifth Ave allowed in Fifth Ave Roles BPR User Count of Role No More license Client Logo Page 1 of 1 Sage biscovery 8 Audit 0 2 3 4 0 61 1 64 1 8 4 4 1 4 3 4 0 64 4 4 2 14 4 4 4 58 0 1 eureKify Sage Discovery 8 Audit Figure 37 Sage Policy Status Report Page 38 Version 3 1 Eurekify 2 4 Version 3 1 SageReports Survey Reports Prerequisites Survey reports are used in the process of a survey and usually require a pre m
10. Config ConfigwIthRoles3 itCard ConfigWIthRoles3Audit 1 Score Threshold Resources Total Alerts in AuditCard 6 Total Resources in 83 Very Low Under 100 0 0 096 Configuration D 096 100 0 0 0 0 0 0 0 6 7 2 7 23 Top 10 Suspects ResName2 ResName3 Score UGADGEN1 Administration NOVELADM Novell4 100 ROOT UGMPBR RACFPROD RACF22 100 public UNXMARKT Solaris26 100 ugrkgen1 UNXMARKT Solaris26 100 e mail outlook WinNT 100 office2003 2003 WinNT 100 Page 1 of 1 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 43 Suspected Collectibles Resources Page 48 Version 3 1 Eurekify SageReports 2 4 7 Suspected Role Definitions General This report keeps track of the suspected role definitions that appear in the given AuditCard including how many alerts are there in each severity based on the alert s score with a pie chart and a list of the top 10 collectibles Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Entities Checkboxes Suspect Roles Version 3 1 Page 49 Eurekify SageReports Suspected Role Definitions ES onfigWithRole Total Alerts in AuditCard Very Low Under 1443 1 1 096 Total Roles in Configuration 96 0 0 0 1 1 0 Average Score 1443 0 0 0 1242 39 0 0 0
11. Reports for inspecting the difference between two configurations in terms of Users present in the current configuration as compared to those present in an old or base configuration In addition the report groups the users by a chosen user category for instance Organization Parameters Old Configuration Current Configuration Category From To choose range User Change Certification Report 9 12 2008 ASS Old Configuration ConfigWithRoles Current Configuration Config Rule1 Category Organization Removed Category Application Development 8 Users Removed 57644540 Alex Patrick Application Development Local 65656540 Pheonix William Application Development Corporate 77292450 Keren Cindy Application Development Corporate 86446130 Bizman Michelle Application Development Corporate 87347830 Mike Pamela Application Development Corporate 94362210 poster Jillian Application Development Corporate 98383830 Capel Linda Application Development Corporate 98732770 Brazil Bill Application Development Corporate Common Category Database Administrators No Change In This Category Removed Category Fifth Ave Branch Client Logo Page dota eure ify Sage Discovery 8 Audit Sage Discovery amp Audit Figure 55 User Change Certification Report Page 70 Version 3 1 Eurekify 2 7 2 Version 3 1 Users Privileges Certification Report SageReports General A report for thoroughly inspecting users privileges
12. Bij So Dan j and Testing Ressource Center ike KL mah co x Y char 4 Atn Seerer Reporting Services a Sagohomorts a Configuration Roports onfiguration Properties Report D select a vakar Figure 13 Navigation Between Folders Explorer via the Microsoft GUI In this view the Reports Database displays the SDB icon Note The new database must be created by either Sage or SageReports prior to running this script Eurekify SageReports To Change Datasource of the Reports Database 1 Open the Sage Reports home page using the Microsoft GUI 2 Open the SageReports folder 3 Click the SDB link to the SDB page E Report Manager Microsoft Internet Explorer File Edit View Favorites Tools Help a Qs 7 x a vo X Search She Favorites e 2 wj gt lan rel 33 Address amp l http flocalhost Reports Pages Folder aspx ItemPath o2fSageReports amp ViewMode List Go Links gt A A Home My Subscriptions Site Settings Hel SQL Server Reporting Services V paons gs Help Home gt Search for sd C SageReports Cu New Folder New Data Source Upload File f Report Builder how Details E About SageReports Privileges Certification Reports m Auditing and Compliance Reports L3i Role Engineering Reports C3 Configuration Reports Role Maintenance Reports Custom Reports SDB m Database Reports Survey Reports 3 Local intranet 4 Inthe SDB pa
13. Organization System Characteristic Role 80 100 Management SYSGNRL Sage Role IT 100 Title Accountant Characteristic Role 50 80 RACFTEST New Role Iterated New Org 80 Page 1 of 1 eure ify Sage biscovery amp Audit Sage Discovery amp Audit Figure 51 Overlapping Roles by Resources Report Page 64 Version 3 1 Eurekify 2 5 2 5 1 Version 3 1 Role Engineering Reports Role Analysis Report SageReports General A report for thoroughly inspecting and analyzing roles It shows all the role s linked entities users resources and sub parent roles as well as various role related alerts from an AuditCard Almost Matching Users Resources Suspect Users Resources Parent Child Hierarchy opportunity and Subsumed overlapping roles Parameters Configuration AuditCard Top default all By Field which role field to chose roles by From to choose a range Pattern Prerequisites AuditCard which has the following alerts selected Tab Similar Roles and role hierarchy check all the boxes Page 65 Eurekify SageReports 26 10 2005 Role Analysis Report loupe onfiguration Config WItk Role ADMGNRL Role ID 1150 BYTT alii Sage Role Role Name ADMGNRL Owner SageBank Organization jg Create Date Role Type core 000 565 Direct Users Users count 10 Person ID User Name Organiz tion Organization Type 58723810 Miles Buyer Purcha
14. Role 0 0 Average STD DEY 1 6 SubRoles for TOP 10 Roles SubRoles for TOP 10 Roles 1 Role ParentRole Connections Direct Indirect Dual Total 23 101 0 124 Roles with NO Parent Roles 73 ParentRoles Per Role 1 0 TN 7 Average Par Roles for TOP 10 Roles 4 STD DEV 2 8 4 Par Roles for TOP 109 Roles Page 1 of 2 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 40 Privileges Statistics Report for Roles Page 42 Version 3 1 Eurekify 2 4 4 Users and Resources Overview Analysis Report SageReports General A survey report Shows an analysis of users including how many users with few resources users who are collectors users who have suspect connections The report includes a pie chart and similarly for resources Parameters Configuration AuditCard Collectors Collectibles and Suspected User Resource Connections Thresholds These parameters determine the minimum score for an audit alert to be counted for the purpose of the survey Meaning if there are 10 collectors alerts in the AuditCard and 8 of these have score higher than 80 and the collectors threshold is 80 then the report would show 8 collectors Note that the parameters section of the screen shows the average score and standard deviation of each of the alerts to help the user decide on the desired thresholds Also the threshold fields are automatically filled with the proposed default value which
15. UGF TRLK UGSAVELAN NTSA VE WinNT UGSAVELAN NTSA VE INT UG ELAN NTSA VE WinNT anization Database ministrators T NOVELAD M Novell4 Organization UGAPPLDEV Admi Application Development UGFTRLK UGADSYS Adminis tration ROOT NOVELAD M Novell4 Page 1 of8 Sage biscovery amp Audit 65 56 55 in a 51 eure ify Figure 33 AuditCard Basic Alerts Report Page 34 Version 3 1 Eurekify SageReports 2 3 3 AuditCard Properties Report General A report that displays various properties of a given AuditCard such as how many alerts of each type are there and in what status average scores and pie charts showing alert distribution Parameters Configuration AuditCard AuditCard Properties Report 11 13 2006 12 35 PM Config ConfigWithRoles AuditCard ConfigWithiRoles Audits Audit Type Groups Entities with many in Out of pattern op Similar resources Similar Role amp Role Suspected Connect Suspected Entities Audit Type Group Entities with many few connections Types 44 0 100 200 300 ype gS A OR oe ee Ke Suspect Role Definitior 834 2 0 0 0 2 0 D 2 Suspected Collacto 266 3 0 0 0 3 3 D D Herarchy Opportunity Parent Child 100 164 0 0 0 164 e a9 Suspected Collective 100 E 0 0 0 4 4 0 Role Resources Covered By Another m 161 0 0 0 161 D 89 Rola Subsumad By Another Sama Users 7 38 0 0 0 38 0 Et Role U
16. V3 0 for yourself or for anyone who uses this computer O Everyone Just me Cancel Select the Installation Folder Figure 3 Click Next and the Confirm Installation step appears Click Next to start the installation process T Er if Eurekify Sage Reports V3 0 Confirm Installation The installer is ready to install Eurekify Sage Reports V3 0 on your computer Click Next to start the installation Cancel lt Back Figure 4 Confirm Installation The process may take a few minutes A progress bar is displayed while the installation takes place When the installation is finished the Sage Reports Information step appears 8 Click Next to move to the Completion step and then click Finish to exit the wizard Page 5 Version 3 1 Eurekify SageReports 1 3 Introducing the Reports After you have finished installing Sage Reports open a browser and go to http localhost reports The browser should open the reports server and display the SageReports folder This indicates that Sage Reports was successfully installed 3 Report Manager Microsoft Internet Explorer File Edit View Favorites Tools Help Ow O HAG Dm km 2 3 ALS Address AE http fflocalhost reports Pages Folder aspx Ee ws Home My Subscriptions Site Settings Help SQL Server Reporting Services Home Search for BEIM Contents EA Cu New Folder New Data Source Upload File Report Builder EE Show De
17. WinNT 16 UGSAVEMGR NTSAVE WinNT lient L f Client ogo Page 1 of 4 eure y Sage biscovery amp Audit Sage Discovery amp Audit Figure 30 Database Resources Report Version 3 1 Page 31 Eurekify SageReports 2 2 4 Database Resources Detailed Report General Lists some all of a database s resources including ALL resource fields Parameters Resources Database By Field Which resource field to choose users by From To Choose a range of values or leave empty for all Pattern Show only resources who match a pattern Database Resources Detailed Report EE ase ResDB By Field R Pattern Res ID APPLDEV Res Name 2 RACF22 Owner Location 63 Res Name 1 appldev Res Name 2 appldev Res Name 3 Solsris2s Owner MRKTLAN Organization Marketing Sun Server Location Marketing Sun Server Res ID 64 Res Name 1 Res Name 2 a aritst Res Name 3 Owner BE 8 RANCHSAVE Organization Location 1 Res Name 1 BRLIMSYS Res Name 2 BRLIMSYS Resnames QE Owner MYSPROD Organization Production RACF Location Production RACF Res ID Res Name 1 Res Name 2 Res Name 3 Location Production RACF Res Name 1 DEVELOP Res Name 2 DEVELOP Res Name 3 RACF22 Owner MYSTEST Organization E Test RACF Location Test RACF e Client Logo a eure ify Sage Discovery amp Audit Sage biscovery 8 Audit Figure 31 Database Resources Detailed Report Page 32 Version 3 1 Eurekify SageReports 2 3 Auditing and Compliance Reports
18. WinNT Suspected 41 No Resource Removed Figure 62 Role Reapproval Report Page 78 Version 3 1 Eurekify SageReports 2 7 9 Role User Membership Reapproval Report Version 3 1 General Compares two configurations and reports the differences on user assignment to Roles Newly added roles are listed along with the users assigned to those roles Roles that were removed are listed without any reference to the users that were assigned the roles Parameters Old Configuration Current Configuration Current Audit Card Category From To choose range Role User Membership Reapproval Report 9 25 2006 6 04 PM Old Configuration ConfigWithRoles Current Configuration ConfigWithRoles1 From Organization Fifth Ave Branch To Organization Fifth Ave Branch 1 Common Roles Role Description Role Organization Organization Eagle Richard Characteristic Role 8096 Fifth Ave Branch Fifth Ave Branch Username Organization Organization Type 67565330 Schwarts Barry Human Resources Corporate Suspected 41 74733340 Lu marry Peter Stamford Branch Branches Suspected 28 89123470 Sharon Johnson Fifth Ave Branch Branches 89213478 Hill Silver Fifth Ave Branch Branches 91238730 Deer Alex Fifth Ave Branch Branches 94738470 German Tom Fifth Ave Branch Branches Figure 63 Role User Membership Re approval Report Page 79 CHAPTER 3 Subscribing to Reports Sage reports are arranged wit
19. pattern Database Users Detailed Report EE Person ID 45489940 User Name Steiven Pat Organization System Management Organization Type Corporate Country US Location Pennsylvania Security Admin Manager Cost Center 24123 11234 Person ID 47868650 mem Name Moris Bill Organization System Management EEE corporate us Location Pennsylvania Developer Cost Center 24123 Person ID 52656727 User Name Radman Adam Organization System Management Organ i ation Type Corporate Country US Pennsylvania Person ID 54672910 User Name Cooper Amos Organiz tion IT Security Organization cor or2te US Location Pennsylvania IT Manager Cost Center 26266 11234 Person ID 57644540 User Name Alex Patrick Organization Application Development Organization Type Corporate Country US Location Pennsylvania Developer Cost Center 30111 Person ID 58723810 User Name Miles Buyer Organization Purchasing ion Type Corporate US SEE New Jersey Purchasing Manager Cost Center 32444 11234 o Client Logo res eure ify Sage Discovery amp Audit Sage biscovery 8 Audit Figure 29 Database Users Detailed Report Page 30 Version 3 1 Eurekify SageReports 2 2 3 Database Resources Report General Lists some all of a database s resources one per line Parameters Resources Database By Field Which resource field to choose users by From To Choose a range of values or leave empty for all Pattern Show only resources who match a pattern 26 10 2005 56 Database
20. see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes User Resource Dual Links Version 3 1 Page 57 Eurekify SageReports Suspected Connections Dual User Resource 077 77 Config 2 AuditCard ConfigWIthRoles3Audit1 Total Dual Links 146 Top 10 Connections With Dual Links User Resource Persor User Name Res Name 1 Res Name 2 Res Name 3 45489940 Steiven Pat UGSAVELAN NTSAVE WinNT 45489940 Steiven Pat UGSAVESYS NTSAVE WinNT 45489940 Steiven Pat UGSTAMLAN NTSTAM WinNT 45489940 Steiven Pat UGSTAMSYS NTSTAM WinNT 45489940 Steiven Pat UGSILVLAN NTSILV WinNT 47868650 Moris Bill UGMPSYS RACFPROD RACF22 47868650 Moris Bill e mail outlook WinNT 47868650 Maris Bill office2003 2003 WinNT 52656727 Rodman Adam public UNXMARKT Solaris26 52656727 Rodman Adam ugrksys UNXMARKT Solaris26 Top 10 Suspected Users With Dual Links User Alerts PersonID User Name 45489940 Steiven Pat 5 67283470 Angel Ben 5 65656540 Pheonix William h 64646410 Herman Barbara 5 57644540 Alex Patrick 5 75675330 Davis Brett 5 77292450 Keren Cindy 5 84848110 Fidelity Bob 5 86544420 Fred John 5 87347830 Mike Pamela 5 Top 10 Suspected Resources With Dual Links Resource Alerts ResNamel ResName2 ResName3 office2003 2003 WinNT 17 e mail outlook WinNT 17 public UNXMARKT Solaris26 7 UG
21. 1 2 2 4 Database Resources Detailed Report esse 32 2 3 Auditing and Compliance Reports iese see se se ee ke ke ee Re ee ee ee 33 2 3 Sage Policy Report eee asi ti ee GED 33 2 3 2 AuditCard Alerts Report eese emen 34 2 3 5 AuditCard Properties Report eese eene 35 2 3 4 AuditCard Alerts by Type Group s 36 2 3 5 Policy Verification Report bs 37 2 3 6 Sage Policy Status Report s 38 DA Survey REPONS 1904 ete e eee te iem re bete 39 2 4 1 Privileges Statistics Report for Users as 40 2 4 2 Privileges Statistics Report for Resources osses 41 2 4 5 Privileges Statistics Report for Roles essen 42 2 4 4 Users and Resources Overview Analysis Report ee ee 43 2 4 5 Suspected Collectors Users eese eene 45 2 4 6 Suspected Collectible Resources seen 47 2 4 7 Suspected Role Definitions eese 49 2 4 8 Suspected Connections User Resource eese 51 Version 3 1 Page iii Eurekify 2 4 9 Suspected Connections User Role sese 53 2 4 10 Suspected Connections Role Resource iese ee ee ee 55 2 4 11 Suspected Connections Dual User Resource ee 57 2 4 12 Suspected Connections Dual User Role see 59 2 4 13 Suspected Connections Dual Role Resource esses 59 2 4 14 Suspected Connecti
22. 2 3 1 Version 3 1 Sage Policy Report Parameters BPR File 11 13 2006 Sage Policy Report 12 22 PM Sage Policy BankPolicy bor RuleID Business Process Rule Name HR 1 HR people must have access to this resource BPR Role Resource L Must Have R Left Entities Right Entities RACFPROD RACF22 Business Process Rule Name Geo Stamford Roles limited to this branch BPR Role Role Only lt L gt May Have lt R gt Left Entities Right Entities BSTAMMGR BSTAMSPRIV BSTAMJI Dev Seg of Duty One person is not allowed on teams that develop in different computing environments BPR Segregation of Duty Roles No More Left Entities Right Entities Finance Cayman Onsite 1 People in Cayman are only allowed to these roles BPR Role Role lt L gt Only Allowed to Have lt R gt Left Entities Right Entities Finance Cayman Onsite 2 People in Cayman must be in this role BPR Role Role L Must Have R Left Entities Right Entities Finance Cayman Onsite 3 And only people in Cayman are allowed in this role BPR Role Role Only L May Have R Left Entities Right Entities Business Process Rule Name Finance Cayman Onsite 4 Type BPR Role Role L Forbidden to Have R Left Entities This is not consistent with previous assertions Right Entities TSFINI Client Logo eurekify Sage Discovery amp Audit Sage Discovery amp Audit Figure 32 Sage Policy Report G
23. 4 9 13 75464420 Cohen Steve System Management Corporate 0 6 5 5 54672910 Cooper Amos IT Security Corporate 0 5 4 5 75675330 Davis Brett Corporate 0 8 6 8 91238730 Deer Alex Fifth Ave Branch Branches 0 5 4 4 Devin Roger Marketing_Dept Corporate 0 6 6 6 89653230 Doll Charles Database Corporate 0 6 6 6 Adminis Eagle Richard Fifth Ave Branch Branches 0 T 7 7 Ester Roger Operations Corporate 0 5 4 4 Fidelity Bob Operations Corporate 0 9 6 6 Flag Lee IT Security Corporate 0 4 3 Fred John em Management Corporate 0 13 10 18 Free Georgia Marketing_Dept Corporate 0 5 4 4 Garr Jim Marketing_Dept Corporate O 4 5 5 German Tom Fifth Ave Branch Branches 7 7 7 89123140 Godheart Dan IT Security Corporate 0 4 3 4 84847310 Goid Wiliam Human Resources Corporate 0 7 4 4 88311130 Goodman Bruce Marketing_Dept Corporate 0 9 8 8 Client Logo eure v if Page 1 of 2 y Sage biscovery amp Audit Sage biscovery amp Audit Figure 19 Configuration Users Report Page 20 Version 3 1 Eurekify SageReports 2 1 4 Version 3 1 Parameters Configuration By Field which user field to chose users by Configuration Users Detailed Report General Lists some all of a configuration s users including ALL user fields From To Choose a range of values or leave empty for all Pattern Show only users who match a pattern Person ID Organization Country Title Direct Res Person ID Organization Country Tit
24. 80 1 Roles for TOP 10 Users 8 Users per Resource Connections of Users m o Number of Resource Connections Users per Role Connections of Users Number of Role Connections Users with NO Resources 1 Resources Per User 6 0 Average STD DEV 2 8 Users with NO Roles Roles Per User 5 0 Average Roles for TOP 10 Users 8 STD DEY 3 8 26 10 2005 12 54 o mmm E Ed EJ mm Ee my 0 2 4 5 6 7 8 9 10 13 14 T de eurekify Sage Discovery amp Audit Sage Discovery amp Audit Figure 38 Privileges Statistics Report for Users Page 40 Version 3 1 Eurekify 2 4 2 Version 3 1 Privileges Statistics Report for Resources General Shows general counters and statistics about configuration resources resource user connections and resource role connections including bar charts Parameters Configuration SageReports Privileges Statistics Report for Resources Configuration ConfigWIthRoles3 26 10 2005 12 55 Configuration Entities for ConfigWIthRoles3 Users Roles Resources 67 96 83 Resource User Connections Direct Indirect Dual Total 264 37 301 Resources with NO Users 19 Users Per Resource 3 0 Average Users for TOP 10 Resources 7 STD DEV 4 5 Users for TOP 10 Resources 7 Resource Role Connections Direct Indirect Dual 2 223 208 Resources with NO Roles 21 Roles Per User Average Roles for TOP 10 Resources 9 DEEP ET A STD DE
25. CF 7 D public UNXMARKT MRKTLAN 10 n purchas UNXMARKT MRKTLAN 2 D root Solaris26 MRKTLAN keting Sun D A secmgr Solaris26 MRKTLAN arketing Sun 2 O Server SYS1 RACFPROD RACF22 MVSPROD Production RACF D D SYS1 RACFTEST EST Test F D FPROD OD Production RACF D O TESTDEV FPROD MVSPROD Production RACF 2 D TESTDEV RACFTEST RACF22 TEST 2 D ucisdev UNXMARKT Solaris26 MRKTLAN g Sun 1 0 ngr UNXI KT Solaris26 MRKTLAN g Sun 2 0 ucisusr UN ARKT MRKTLAN Sun 3 D UGSAVEGEN NTSAVE WinNT BRANCHSAVE 4 0 U ELAN NTS WinNT NCHSAVE 3 D Client Logo eure eif Page 1 of 2 y Sage biscovery amp Audit Sage biscovery amp Audit Figure 22 Configuration Resources Report SageReports Page 23 Eurekify 2 1 7 Parameters Configuration Configuration Resources Detailed Report General Lists some all of a configuration s resources including ALL resources fields By Field which resource field to choose users by From To Choose a range of values or leave empty for all Pattern Show only resources that match a pattern From APPLDEV Res Name 2 Owner Location Direct Users Res ID Res Name 2 Owner Location Direct Users Res ID Res Name 2 Owner Location Direct Users Res ID Res Name 2 Owner Location Direct Users Res Name 2 Owner Location Direct Users ACFTEST To UGSILVGEN TSII V WinNT 0 RACFTEST 63 UNXMARKT MRKTLAN Marketing Sun Server BNTSAVE BRANCHSAV
26. E Total Users 1 RACFPROD MYSPROD Production RACF Total Users RACFPROD MYSPROD Production RACF 26 10 2005 Configuration Resources Detailed Report Ad Config ConfigWIthRoles3 By Field ResName123 Pattern Sort Ascending APPLDEV Res Name 3 RACF22 Organization Total Roles a Res Name 1 appldev Res Name 3 Solaris26 Organization Marketing Sun Server Direct Roles Total Roles Res Name 3 WinNT Organization Direct Roles Total Roles Res Name 1 BRLIMSYS Res Name 3 RACF22 Organization Production RACF Direct Roles Total Roles Res Name 3 RACF22 Organizatio Production RACF Total Roles Client Logo Page 1 of 14 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 23 Configuration Resources Detailed Report SageReports Page 24 Version 3 1 Eurekify 2 1 8 Configuration Resources Full Report General Lists some all of a configuration s resources including each resource s roles and users Parameters Configuration By Field which resource field to choose users by From To Choose a range of values or leave empty for all Pattern Show only resources that match a pattern 26 10 2005 Configuration Resources Full Report AES Config ConfigWIthRoles3 By Field ResName123 From Pattern Sort Ascending Resource APPLDEV RACFTEST RACF2 ResourceID Res Name 1 Res Name 2 Organization Res N
27. Herman Barbara Operations Corporate 9 6 6 82653450 Hill Gary Fifth Ave Branch Branches 0 6 6 6 Hill Silver Fifth Ave Branch Branches 0 5 4 91724340 Hope Collin Finance Corporate 9 10 10 97373330 Katz Nancy Silicon Valley Branch Branches 8 8 8 Client Logo eure ify Sage biscovery 8 Audit Figure 18 Configuration Entities Report Page 19 Eurekify SageReports 2 1 3 Configuration Users Report General Lists some all of a configuration s users one per line Parameters Configuration By Held which user field to chose users by From To Choose a range of values or leave empty for all Pattern Show only users who match a pattern SortByTotals Disabled by default enables sorting of the results by total number of roles or resources for easy viewing of users with no roles resources H 26 10 2005 Configuration Users Report Config ConfigWIthRoles3 By Field UserName From Alex Patrick To Kistor Steve Pattern Person ID User Name Organization Org Type 57644540 Alex Patrick Application Corporate 0 4 4 Angel Ben Corporate 13 10 18 Atek Rogers Fifth Ave Branch Branches 0 5 4 4 Bean Frank Purchasing Corporate 0 7 4 4 Bell Kim Marketing Dept Corporate 0 5 4 4 Bizman Michelle Application Corporate 0 4 4 4 Development 98732770 Brazil Bill Application Corporate 0 6 3 3 Development Capel Linda Ap Corporate 0 10 5 5 De 89753140 Cherry Jay Fin Corporate 1
28. Organization Type Match 83838380 Helmuth Howard Marketing Dept Corporate 87635420 Bell Kim Marketing Dept Corporate BO 93833870 Free Georgia Marketing Dept Corporate BO Proposed New Users None Direct Resources Figure 61 Role Certification Report by Role Category Version 3 1 Page 77 Eurekify SageReports 2 7 8 Role Reapproval Report General Reports the differences in a Role between two configurations in terms of User Privileges Sub Roles and Resources based on a selected Category for instance RoleName Parameters Old Configuration Current Configuration Current Audit Card Category From To choose range Role Reapproval Report 9 25 2006 6 01 PM Old Configuration ConfigWithRoles Current Configuration ConfigWithRoles1 RoleOwner Role Description Role Organization Organization Eagle Richard Characteristic Role 80 Fifth Ave Branch Fifth Ave Branch 1 Username organization Organization Type 67565330 Schwarts Barry Human Resources Corporate Suspected 41 74733340 Lu marry Peter Stamford Branch Branches Suspected 28 Users Removed 4 username Organization organization pe 89123470 Sharon Johnson Fifth Ave Branch Branches 89213478 Hill Silver Fifth Ave Branch Branches 91238730 Deer Alex Fifth Ave Branch Branches 94738470 German Tom Fifth Ave Branch Branches No Sub Roles Added No Sub Roles Removed UGSAVELAN NTSAVE WinNT UGSAVEMGR NTSAVE WinNT UGSAVESYS NTSAVE
29. PORTING FILES IN VARIOUS FORMATS sesse esse sesse ee ee ee ee ee ee ee ee ee ee ee 13 INSTALLING CUSTOMER LOGO sees 14 CONFIGURATION PROPERTIES REPORT esse ee ee ees ee ee ee ee ee ee ee ee 18 CONFIGURATION ENTITIES REPORT esse sees esse se ee ee ee ee ee ee ee ee ee 19 CONFIGURATION USERS REPORT eise ese see ese ee ee ee ee Re 20 CONFIGURATION USERS DETAILED REPORT 21 CONFIGURATION USERS FULL REPORT CONFIGURATION RESOURCES REPORT CONFIGURATION RESOURCES DETAILED REPORT cccccccesssssseeeeeeees 24 CONFIGURATION RESOURCES FULL REPORT eene 25 CONFIGURATION ROLES REPORT 26 CONFIGURATION ROLES DETAILED REPORT ccseesseeeceeeessssnseeeceeees 27 CONFIGURATION ROLES FULL REPORT c scccccesesssssseeeceeeeessssseeeeeeees 28 DATABASE USERS REPORT ee a a A EA R 29 DATABASE USERS DETAILED REPORT 30 DATABASE RESOURCES REPORT sssssscsseecessssseeeceecesesssseeeceeeesessssseees 31 DATABASE RESOURCES DETAILED REPORT ccccccsesesssseeeceeeesenssseeees 32 SAGE POLICY REPORT esse sees esse ee ee AUDITCARD BASIC ALERTS REPORT AUDITCARD PROPERTIES REPORT iese sesse ee ee ee ee ee ee ee ee ee ee ee ee ee e AUDIT CARD ALERTS BY TYPE GROUP esse sesse sesse ee ee ee ee ee ee ee ee 36 POLICY VERIFICATION REPORT esse sees sees se as 37 SAGE POLICY STATUS REPORT 38 PRIVILEGES STA
30. RACFTEST RACF22 36 98383830 Capel Linda DEVELOP RACFPROD RACF22 36 98383830 Capel Linda DEVELOP RACFTEST RACF22 36 97373330 Katz Nancy UGSILVGEN NTSILV WinNT 36 97847110 Taskoni Bob UGSILVSYS NTSILV WinNT dt 87347830 Mike Pamela UGADGEN2 Admi NOVELADM Novell4 31 nistration ROOT 94738470 German Tom UGSAVESYS NTSAVE WinNT 31 98662230 Tortia Dan UGSTAMSYS NTSTAM WinNT 31 Page 1 of 1 eure ify Sage biscovery 8 Audit Sage Discovery 8 Audit Figure 45 Suspected Connections User Resource Page 52 Version 3 1 Eurekify SageReports 2 4 9 Suspected Connections User Role General This report keeps track of the suspected user role connections that appear in the given AuditCard including how many alerts are there in each severity based on the alert s score with a pie chart and a list of the top 10 suspected connections Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes User Role Connections Version 3 1 Page 53 Eurekify SageReports 26 10 2005 12 59 Suspected Connections User Role nfig les 1 s3Audit1 Score Threshold Connections 33 very Low Under 30 16 4 2 380 1 8 7 67 7 1 8 0 096 96 3 0 896 91 3 4 2 1 8 1 8 0 8 Top 10 Suspected Connections User Role Aler
31. REPORT BY ROLE CATEGORY esse see ee ese ese ee 71 FIGURE 62 ROLE REAPPROVAL REPORT s sccscccsessessceececeeeessssceececcessessseeeeeeeesens 78 FIGURE 63 ROLE USER MEMBERSHIP RE APPROVAL REPORT 79 Page vi Version 3 1 Preface Version 3 1 About This Manual Sage Reports is a powerful reporting platform based on Microsoft SOL Server Reporting Services It offers a comprehensive set of reports that ranges from simple enumerating reports to sophisticated analytical ones Using the reports will enable you to easily extract meaningful data from your Sage database This guide will help you get started This manual describes background and general information on Sage Reports provides a description of each report and describes how to subscribe to reports CHAPTER 1 Describes the prerequisites needed for installing and running Sage Reports installation instructions and provides general information for operating and viewing and exporting reports CHAPTER 2 Provides a brief description of each report indicating the parameters and prerequisites required to produce the report and provide a sample output of each report CHAPTER 3 Describes how to subscribe to Sage reports Who Should Use This Manual This manual is intended for System Engineers Role Engineers Business line managers alike Anyone who is likely to need to install Sage Reports Customize the Reports and Produce the Reports This manual assumes that th
32. Resources Report gt Te rt APPLDEV C ST RACF22 63 appldev Solari MRKTLAN Marketing Sun Marketing Sun Server Server 64 aritst NTSAVE WinNT BRANCHSAVE 1 BRLIMS RACFPROD MYSPROD Production Production RACF 2 DEVELOP RACFPROD RACF22 Production Production RACF R 3 DEVELOP RACFTEST RACF22 MYSTEST 4 Domain Users NTSAVE WinNT BRANCHS 6 Domain Users NTSILV WinNT BRANCHSILV 5 Domain Users NTSTAM WinNT BRANCHST AM 81 e mail outlook WinNT 82 office2003 2003 WinNT 7 PUBLIC RACFPROD RACF MVYSPROD Production Production RACF RACF 8 PUBLIC RACFTEST MYSTEST Test RACF T RACF 65 public UI AARKT MRKTLAN Marketing Sun Marketing Sun Server Server 66 purchase UNXMARKT Solaris26 MRKTLAN Marketing Sun Marketing Sun rver Server 67 root UNXMARKT Solaris26 MRKTLAN Marketing Sun Marketing Sun Server Server 68 secmgr UNXMARKT MRKTLAN Marketing Sun Marketing Sun Server 9 SYS1 CFPROD MVSPROD Production RACF 10 ACFTEST RACF22 MVSTEST Test RACF 11 RACFPROD RACF22 MVSPROD Production Production RACF RACF 12 TESTDEV RACFPROD RAC MVYSPROD Production Production RACF RACF 13 TESTDEV RACFTEST RAC MYSTEST Test RACF Test RACF 69 ucisdev UNXMARKT Solaris26 MRKTLAN Marketing Sun Marketing Sun Server Server 70 ucismgr UNXMARKT MRKTLAN Marketing Sun g Sun Server 71 UNXMARKT Solari MRKTLAN Marketing Sun Marketing Sun Server Server 14 UGSAVEGEN NTSAVE WinNT 15 UGSAVELAN NTSAVE
33. SAVESYS NTSAVE WinNT 6 UGSILVLAN NTSILV WinNT 6 UGSTAMSYS NTSTAM WinNT 6 UGTELSAVE TSSCREDIT TSS50 5 DEVELOP RACFTEST RACF22 4 DEVELOP RACFPROD RACF22 4 UGMPBR RACFPROD RACF22 4 Client Logo eurekif Page 1 of 1 Y Sage Discovery amp Audit Sage Discovery amp Audit Figure 48 Suspected Connections Dual User Resource Page 58 Version 3 1 Eurekify SageReports 2 4 12 Suspected Connections Dual User Role General This report keeps track of the dual links between users and roles in the given AuditCard It shows all top 10 of the connections users and roles involved in dual links Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes User Role Dual Links This Report is similar to the previous report 24 13 Suspected Connections Dual Role Resource General This report keeps track of the dual links between roles and resources in the given AuditCard It shows all top 10 of the connections roles and resources involved in dual links Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes Role Resource Dual Links This Report is similar to the previous repo
34. TISTICS REPORT FOR USERS eene 40 PRIVILEGES STATISTICS REPORT FOR RESOURCES eee 41 PRIVILEGES STATISTICS REPORT FOR ROLES USERS AND RESOURCES ANALYSIS REPORT SUSPECTED COLLECTORS USERS cccsssssscceceeeeessssceeeceeeessssseeeeceeseneees SUSPECTED COLLECTIBLES RESOURCES SUSPECTED ROLE DEFINITIONS esse ee ee ees eene nnne nennen SUSPECTED CONNECTIONS USER RESOURCE esse ee ee ee ee ee ee ee ee SUSPECTED CONNECTIONS USER ROLE ees see ee ese ee ee ee ee ee ee SUSPECTED CONNECTIONS ROLE RESOURCE eene SUSPECTED CONNECTIONS DUAL USER RESOURCE sesse ee ee 58 ROLE ENGINEERING METHODOLOGIES COMPARISON cen 61 OVERLAPPING ROLES BY USERS REPORT eene OVERLAPPING ROLES BY RESOURCES REPORT ROEE ANALYSIS REPORT iii ii rettet va suue aina sds ska Ye ube Page v Eurekify SageReports FIGURE 53 ROLES APPROVAL STATUS REPORT 67 FIGURE 54 USERS ROLE BASED PRIVILEGES aa 68 FIGURE 55 USER CHANGE CERTIFICATION REPORT ccce 70 FIGURE 56 USERS CERTIFICATION REPORT BY CATEGORY eee 72 FIGURE 57 USER PRIVILEGES RECERTIFICATION REPORT eene 73 FIGURE 58 USER ROL PRIVILEGES RECERTIFICATION REPORT 74 FIGURE 59 USER PRIVILEGES CHANGE REQUESTS REPORT eee 75 FIGURE 60 CERTIFICATION PROGRESS STATUS REPORT 75 FIGURE 61 ROLE CERTIFICATION
35. UGMPBR RACFPROD RACF22 UGTELSAVE TSSCREDIT TSS50 ugrkgeni UNXMARKT Solaris26 e mail outlook WinNT office2003 2003 WinNT Figure 57 User Privileges Recertification Report Page 73 Eurekify SageReports 2 7 4 Users Role Privileges Recertification Report General Reports the differences between two configurations in terms of User Privileges their Roles and Resources based on a selected Category for instance Organization The report can take into consideration alerts listed in an Audit card Parameters Old Configuration Current Configuration Current Audit Card Category From To choose range User Role Privileges Recertification Report 9 13 2006 11 31 AM Old Configuration ConfigNoRoles Current Configuration ConfigNoRoles by org Categor rganization From Fifth Ave Branch To Fifth Ave Branch Common Category Fifth Ave Branch 10 Common Users 67762440 Purple Mary Fifth Ave Branch Branches Roles Info Roles Added 1 GR Organization Fifth Ave Characteristic Role 100 096 Suspected 27 Branch Min 60 No Roles Removed Resources Info No Resource Added Resources Removed 7 Res Name 1 Suspected UGSAVEGEM NTSAVE WinNT UGSAVELAN NTSAVE WinNT UGMPBR RACFPROD RACF22 UGTELSAVE TSSCREDIT TSS50 ugrkgeni UNXMARKT Solaris26 e mail outlook WinNT office2003 2003 WinNT Figure 58 User Rol Privileges Recertification Report Page 74 Version 3 1 Eurekify SageReports 2 7 5 Us
36. V 10 4 Roles for TOP 10 Resources 9 Ui of Resources e of Resources Resources per User Connections Number of User Connections Resources per Role Connections Number of Role Connections 433 5 0 0 t 2 3 4 S 6 7 B 9 Te 13 15 24 lan m 0 M mm mm m 0 1 2 3 4 5 8 7 9 8 n 12 13 19 20 66 Client Logo Sage biscovery 8 Audit Page 1 of 1 eure ify Sage biscovery 8 Audit Figure 39 Privileges Statistics Report for Reso urces Page 41 Eurekify SageReports 2 4 3 Privileges Statistics Report for Roles General Shows general counters and statistics about configuration roles role user connections and role resource connections including bar charts Parameters Configuration 26 10 2005 Privileges Statistics Report for Roles ipee Config ConfigWIthRoles3 Configuration Entities for ConfigWIthRoles3 Roles Resources 96 83 a ES Role Resource Connections Direct Indirect Dual Total 264 54 0 318 Roles with NO Resources 3 Resources Per User aid Average Resources for TOP 10 Roles 6 Resources for TOP 10 Roles Role User Connections Direct Indirect Dual Total 343 35 2 380 Roles with NO Users 5 Users Per Role 3 0 Average Users for TOP 10 Roles 6 i STD DEV 6 8 Users for TOP 10 Roles 6 Role SubRole Connections Direct Indirect Dual Total 23 17 0 40 DEY 2 3 Roles with NO Sub Roles 86 SubRoles Per
37. a browser when the Sage Portal browser is unavailable Page 10 Version 3 1 Eurekify 1 4 3 1 If at some point you wish to change the database that is used as the source for the reports you need to modify the Connection String that is associated with the Sage Reports Database SDB The SDB can only be accessed when viewing the Reports Database from within Microsoft Version 3 1 To view reports via the Microsoft GUI T Open a Microsoft Explorer Browser Enter the URL http localhost Reports The reports folder opens to the Sage Reports home page Where the reports server is located on a different machine you must replace localhost with the IP address or name of that machine Select the Report s folder Select the desired report Enter the reports parameters Usually the Configuration Name Field Name AuditCard Click on View Report and wait for the report to be generated In Order to navigate between folders use the navigation links that appear on top of the page Changing Reports Datasource Connection Parameters Terve piisabki K Services HOMSET My SVUSVAPUJUS SIL HEER TERS T SageReports Help on dd emer Raport 2 ME 01 Configuration Search for sel Properties Report Propertius History zubesript onr x View Report j Figure 12 Generating Reports amp l Mp dee ase Wiese Des upi aspe bere the Leo i PC aar a E BE ID gj Datoram oon dE Report Mirage
38. ade AuditCard that checks for certain alerts Thresholds Some survey reports use score thresholds to divide alerts into categories Alerts with score lt Very Low will be counted in the Very Low category Alerts with score between Very Low and Low will be counted in the Low category and so on The category Very High counts the alerts whose score is higher than the High threshold The OK category counts respective entities in the configuration which do not have an alert For example how many configuration users do not have an alert in the AuditCard You can use the alert statistics displayed above the thresholds such as average score and STDEV to determine the threshold values you want or use the default values which are Score Description Very Low Average Score Low Average 0 5 STDEV Med Average 1 0 STDEV High Average 1 5 STDEV Page 39 Eurekify 2 4 1 Privileges Statistics Report for Users SageReports General Shows general counters and statistics about configuration users user role connections and user resource connections including bar charts Parameters Configuration Privileges Statistics Report for Users Configuration ConfigWIthRoles3 Configuration Entities for ConfigwIthRoles3 Users Roles Resources 67 96 83 User Resource Connections 1 223 209 433 Resources for TOP 10 Users 9 EE R Resources for TOP 10 Users 9 User Role Connections 343 35 2 3
39. als The path has to be a UNC path as illustrated 5 Press the select schedule button and choose the desired schedule and click OK Z Report Manager Microsoft Internet Explorer ek LJ Eile Edit View Favorites Tools Help Q ex c x 2 A JO search She Favorites o Br T iw iw a Address je http localhost Reports Pages SubscriptionProperties aspx CreateNew True amp lsDataDriven False amp lt Y Go Links amp Re t Manager O Reporting Services Google v IG search Q x9 Sizblocked MF Check amp Autolink gt Subscription 01 Search for Configuration Properties Report Use this schedule to determine how often this report is delivered Schedule details Choose whether to run the report on an hourly daily weekly monthly or one time basis All times are expressed in GMT 02 00 Jerusalem Standard Time Odour Daily Schedule pay O Week O Month O Once 9 On the following days Sun LY Mon Tue O Every weekday ORepeat after this number of days 1 Start time 08 oo AM Opm bz Local intranet 6 Fill in the report parameters These parameters will be used when the report is generated according to the specified schedule E Report Manager Microsoft Internet Explorer File Edit View Favorites Tools Help Q sak Q a O Search She Favorites amp tar KES Address ea http localhost Reports Pages SubscriptionPr
40. ame 3 Location Users count 1 User Database Person ID User Name Organization ID ID Organization Type 45489940 Steiven Pat System Management Corporate Roles Name APPLDEV Resource appldev UNXMARKT Solaris ResourcelD 63 appldev Owner MRKTLAN UNXMARKT Organization Marketing Sun Server Solaris26 Location i Sun Server Users Person ID User Name 65656540 Pheonix William Application Corporate Res Name 1 Res Name 2 Users count 3 User Database ID ID Organization Organization Type Development 13 2 75675330 Davis Brett Database Corporate Administrators 44 2 89653230 Doll Charles Database Corporate Administrators Roles Name DBAUNIX APPLDEV o Client Logo eure ify Sage biscovery Audit Sage biscovery amp Audit Figure 24 Configuration Resources Full Report SageReports Version 3 1 Page 25 Eurekify 2 1 9 Configuration Roles Report General Lists some all of a configuration s roles one per line SageReports Parameters Configuration which role field to choose roles by from to values Pattern Parameters Configuration By Field Which role field to choose users by From To Choose a range of values or leave empty for all Pattern Show only role that match a pattern Configuration Roles Report Config ConfigWIthRoles3 Role
41. anch Manager Cost Center ERRIN Role Based Access NTSAVE BRANCHSAVE RACFPROO MVSPROD Production RACF UNXMARKT MRKTLAM Marketing Sun er outlook 21331 11234 Role Based Access NETT TENMNNCT NN BRANCHSTAM BRANCHSTAM MVSPROD Production RACF MRKTLAM Marketing Sun Server Client Logo Page 1 of 2 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 54 Users Role Based Privileges 2 5 4 Role Engineering Methodologies Comparison See 2 4 15 Role Engineering Methodologies Comparison Report on page 61 Page 68 Version 3 1 Eurekify SageReports 2 6 Role Maintenance Reports Descriptions for the reports listed in this section can be found under other sections in the book See the listed cross references 2 6 1 Role Approval Status Report See the description in section 2 5 2 Role Approval Status Report on page 67 2 6 2 Role Approval Report See the description in section 2 7 7 Role Approval Report on page 76 2 6 3 Role Reapproval Report See the description in section 2 7 8 Role Reapproval Report on Page 78 2 6 4 Overlapping Roles by Users See the description in section 2 4 16 Overlapping Roles by Users Report on page 61 2 6 5 Overlapping Roles by Resources See the description in section 2 4 17 Overlapping Roles by Resources Report on page 63 Version 3 1 Page 69 Eurekify SageReports 2 7 Privileges Certification Reports 2 7 1 Users Change Certification Report General
42. ding to their function Currently there are 8 folders Auditing and Compliance Reports Configuration Reports Custom Reports Database Reports Privileges Certification Reports Role Engineering Reports Role Maintenance Reports and Survey Reports Eurekify provides 3 environments for viewing the reports Via a browser using the Sage Portal Via the Sage Portal client application Via a browser using the Microsoft Reporting Services This section provides and overview of each viewing environment and explains the benefits of using each environment Note To view a report in any environment you must first save the source configuration or audit file to the database This is performed o 1 in Sage DNA 1 4 1 Viewing reports via the Sage Portal The Sage Portal serves the day to day purposes of business unit managers and other personnel that need to authorize changes and modifications to user privileges that are suggested by the Role Engineers The Sage Portal GUI is a convenient way for business unit managers to communicate information and stay up to date with modifications made to users roles and resources at the same time eliminating the need for excessive system installation throughout the company Other than for role engineers this is the environment through which Eurekify recommends that most people work this includes viewing reports Note Access to Sage Data Management and Sage DNA e Workstation modules is prevented from wi
43. dow opens containing Parameter fields Enter values for the parameter fields as required for the selected report F Report Microsoft Internet Explorer LJ eure ify The Role Based Management Company Configuration Select a Value Pattern tBy Ti Figure 9 Empty reports window Click the View Report button to generate a report A report is generated and displayed in the area below the options fields Report Microsoft Internet Explorer LJ eure IfY The Role Based Management Company Configuration Users List Configuration ConfigNoRoles w By Field UserName From Alex Patrick v To Cherry Jay Pattern Sort Ascending v Sort By Totals Disabled Id ofi b bi 100 v Find Next Select a format Jerr A 3 Configuration Users Report 10 19 2006 2 33 PM 0 0 Figure 10 Reports window showing a generated report Viewing Reports via the Sage Portal Client Application The Sage Portal Client application provides direct access to all five modules in the Eurekify Sage ERM suite Administration Business Collaboration DNA Workstation DNA Data Management Reports For Role Engineering where work requires you to swap in and out of these modules the Sage Portal client is the ideal environment from which to view reports The Sage Portal Client has the same look and feel as that described for the Sage Portal GUI only that it provides access to all modules in the Eurekify Sage ERM suite Once
44. e Role Engineer has had professional training on a Sage system and is familiar with the Sage documentation that accompanied the Sage installation package Familiarity with the Microsoft operating system and applications and relevant peripheral and remote equipment is also assumed Page vii Eurekify SageReports Document Conventions To facilitate working with this user manual Eurekify has adapted the following symbols in the body of the manual to focus on issues of special importance The user should pay careful attention to sections that contain the following conventions Important information Read carefully mie wl Recommended activity Contact Information Should there be any questions regarding Eurekify products please feel free to contact us directly or contact our local distributors Headquarters Eurekify Ltd 8 Hasadna Street Raanana 43651 Israel Telephone 972 9 746 7346 Facsimile 972 9 746 7347 Email info Ceurekify com Web www eurekify com Page viii Version 3 1 CHAPTER 1 General Background The topics covered in this chapter include Prerequisites What you need to have before installing Sage Reports Installing Sage Reports Walks you through the installation process Introducing the Reports Viewing Reports Basic things you need to know Exporting Reports to other formats Changing the customer logo 1 1 Prerequisites Before insta
45. ected Connections Role Resource Score Threshold Connections Top 10 Suspected Connections 26 10 2005 01 00 AuditCard ConfigWithRoles3Audit1 Total Alerts in AuditCard 96 222 69 896 48 15 196 Total Role Res Connections 318 18 5 7 1 Total Roles 96 5 1 6 20 6 3 METER 83 5 1 696 Alerts Analysis 15 196 5 7 1 6 6 3 1 6 Role Resource Alert RoleID Role Name Res Name 1 Res Name 2 Res Name 3 Score 1150 ADMGNRL UGADGEN1 Admin NOVELADM Novell4 65 istration ROOT 1029 UGFTRLK UGSAVELAN NTSAVE WinNT 56 1143 BSAVELAN UGSAVELAN NTSAVE WinNT 56 1144 BSAVEJ1 UGSAVELAN NTSAVE WinNT 55 1002 Organization UGAPPLDEV Admi NOVELADM Novell4 55 Database nistration ROOT Administrators 1013 Organization UGAPPLDEY Admi NOVELADM Novell4 51 Application nistration ROOT Development 1029 UGFTRLK UGADSYS Adminis NOVELADM Novell4 51 tration ROOT 1102 SYSSUB2 UGADSYS Adminis NOVELADM Novell4 51 tration ROOT 1029 UGFTRLK UGSTAMLAN NTSTAM WinNT Bi Client Logo eure Sify Page 1 of 2 Sage Discovery 8 Audit Sage Discovery amp Audit Figure 47 Suspected Connections Role Resource Page 56 Version 3 1 Eurekify SageReports 24 11 Suspected Connections Dual User Resource General This report keeps track of the dual links between users and resources in the given AuditCard It shows all top 10 of the connections users and resources involved in dual links Parameters Configuration AuditCard
46. ed to access IIS metabase 1 Installation message appears computer Also make sure the path environment variable points to their directory usually C Program Files Microsoft SQL Server 80 Tools Binn IS IIS works but cannot view You must re register asp net with net framework Using the command line go to the net location in the computer This is usually C WINDOWS Microsoft NET Framework v1 1 4322 Run aspnet regiis i Manage Sage Connection Details While trying to connect get the message Failure to connect Enter a value for the Server Name This can be either local or the name of the machine Note that the value for the machine name is case sensitive Make sure that anonymous access is disabled in IIS admin Restart the browser portal client Viewing Sage Reports Cannot view Sage Reports Receive the error User has insufficient privileges rsAccessDenied This is caused by Reporting Services Security 1 Go to report manager http server name gt reports Go to the SageReports folder Click on the Properties tab and choose Security from the left There you see a list of all permitted users groups Add the needed user or group name to this list by clicking new role assignmen typing the user group name and assigning the Browser role Version 3 1 Page 15 Eurekify SageReports Problem Area Error or Message Treatment The report ser
47. elp lt RenderingExtension gt HTMLOWC lt RenderingExtension gt lt Render in Extens i on gt NULL lt Render ingExtension gt lt ExcludedRenderF rmats gt lt Fi leshar econfi guration gt lt configuration gt lt Extension gt Extension Name Report server Email Type Microsoft Reportingservices EmailDel lt MaxRetries gt 3 lt MaxRetries gt secondsBeforeRetry 900 secondsBeforeRetry configuration RsEmailbPConfiguration lt SMTPServer gt SMTPServer gt lt SMTPServerPort gt lt SMTPServerPort gt Your smtp server SMTPACCOUnt Name gt lt SMTPACCOUNtName gt lt SMTPConnectionTimeout gt lt SMTPConnectionTimeout gt lt SMTPServerPickupDirectory gt lt SMTPServerPickupDirectory gt SMTPUSeSSL SMTPUSeSSL lt sendusing gt lt sendusing gt sMTPAuthenticate SsMTPAuthenticate PERPE a ais TENER USES NA SUBIRE ce lt EmbeddedRenderFormats gt From address Render ingExtension gt MHTML lt Render ingExtension gt EmbeddedRenderFormat s PrivilegeduserRenderFormats PrivilegeduserRenderFormat lt ExcludedRenderFormats gt Render ingExtens ion gt HTMLOWC lt Render ingExtension gt lt Render in Extension gt NULL lt Render ingExtension gt lt ExcludedRenderF rmats gt lt sendemai IToUserAlias gt True lt Sendemai 1 Touseralias gt lt DefaultHostName gt lt DefaultHostName gt lt PermittedHosts gt lt PermittedHosts gt lt RSEmai 1DPConfiguration gt lt Confi
48. eneral A report that displays all the Business Process Roles that compose a Policy saved in a BPR file Page 33 Eurekify SageReports 2 3 2 AuditCard Alerts Report General A report that displays some all of the alerts in the given AuditCard according to the given parameters Parameters Configuration AuditCard From To values for EntryID Status Date and Type optional sort by fields Show all alerts or just the most recent ones 12 Suspected 4 Suspected in Suspected 2005 6 Suspected 2 10 19 17 A Suspected Suspected Connections 47 Suspected 23 10 2005 10 19 17 3 10 Suspected 10 2005 10 19 17 63 Suspected a Client Logo Sage biscovery 8 Audit Type Suspect Role Definition Suspect Role Definition Suspected Collector Suspected Collectible Suspected Collectible Suspected Collectible Suspe Collec Suspect Role Res Connection Suspect Role Res Connection spect Role Connection Suspect Role Res Connection Suspect Role Res Connection Connection AuditCard Basic Alerts Report Count 9 BASIC ROLE ADMGNRL 64646410 UGADGEN1 Admini ration ROOT NOVELADM N l4 UGMPBR RACFPRO D RACF22 a mail outlook WinNT 03 2003 Wi Count 111 ADMGNRL UGADGEN1 Admin T NOVELAD M Novell4
49. ent ApplicafiOn ee ee ee es ee 9 143 Viewing Reports via Microsoft Reporting Services ee ee ee ee 10 1 4 3 1 Changing Reports Datasource Connection Parameters se see see 11 1 5 Exporting reports to other formats aaa 13 1 6 Changing Customer Logo seem ener ee ee ke 14 Il Troubleshooting AE AE eie ee Rem 15 CHAPTER 2 SAGE REPORTIS see sesse see sesse see sesse testen See se ese See be ese nsn tasa suus 17 21 Configuratloi Reports AE RE OE ers 18 2 1 1 Configuration Properties Report eese 18 2 1 2 Configuration Entities Report eese eene 19 2 1 3 Configuration Users Report ss 20 2 1 4 Configuration Users Detailed Report as 21 2 1 5 Configuration Users Full Report s 22 2 1 6 Configuration Resources Report esse ese ee ee ee Ge ee ee ee 23 2 1 7 Configuration Resources Detailed Report esses 24 2 1 8 Configuration Resources Full Report as 29 2 1 9 Configuration Roles Report essen 26 2 1 10 Configuration Roles Detailed Report esee 27 2 1 11 Configuration Roles Full Report s 28 2 2 Users and Resources Reports uses see see se Se ee ke E ee ee E 29 2 2 1 Database Users Report s 29 2 2 2 Database Users Detailed Report s 30 2 2 3 Database Resources Report as 3
50. ers Privileges Change Reguest Report General A report that lists all open requests to change user privileges for any user associated with a specified configuration The report includes the name of the user that submitted the request and lists the privileges or resources to be added to or removed from users Parameters Configuration User Privileges Change Requests Report Requested By EUREKIFY LAB User Organization Application Development PersonID 98732770 Brazil Bill Revisions 2 Request Remove Resource UGAPPLDEV Administration NOVELADM Novell4 ROOT Reguest Add Resource DEVELOP RACFTEST Figure 59 User Privileges Change Requests Report 2 7 6 Certification Progress Status Report General Reports on the progress of a specific campaign and lists the status of each campaign target Parameters Campaign Certification Progress Status Report 7 706 1175 Campaign Manual Campaign Target ReguestResources No Campaign Activity yet Campaign Target ReguestRoles No Campaign Activity Yet Campaign Target Res pproval No Campaign Activity Yet Campaign Target RoleApproval No Carr Campaign Target UserCert No Campaign Activity yet Campaign Target UserRecert No Campaign Activity Yet Figure 60 Certification Progress Status Report Version 3 1 Page 75 Eurekify SageReports 2 7 7 Role Approval Report General A report for thoroughly inspecting roles users and res
51. ervices gt Subscription 01 Configuration Properties Report Report Delivery Options Specify options for report delivery Delivered by Report Server E Mail Report Server File Share Use to separate multiple e mail addresses Reply To Subject ReportName was executed at ExecutionTir v Include Report v Include Link Priority Normal a Report Manager Microsoft Internet Explorer File Edit View Favorites Tools Help iy Qs Q x a A A Search Shi Favortes e R 8 w iul d Address amp http j localhost Reports Pages SubscriptionProperties aspx CreateNew True amp IsDataDriven F Y Go Links amp Report Manager a Reporting Services v C Search O 9 S 2bloded MF check Home Mv Subscription Site Settings Hel Search for iG SQL Server Reporting Services Home gt SageReports gt Configuration Reports gt Subscription 01 Configuration Properties Report Report Delivery Options Specify options for report delivery Delivered by Report Server File Share Y File Name 01 Configuration Properties Report Madd a file extension when the file is created Path eurekifyeyal c Share Render Format Choose format Version 3 1 Computer name after drive Page 85 Eurekify SageReports 4 If file share is chosen fill in the path to which the subscribed report will be published and the credenti
52. eurekify Eurekify Sage Reports User Manual Copyright 2007 by Eurekify Ltd 8 Hasadna Street Raanana 43651 ISRAEL All Rights Reserved This document maybe used in its complete form only and is solely for the use of Eurekify and Eurekify employees and authorized Eurekify channels or customers The material herein is proprietary to Eurekify and any unauthorized reproduction either by electronic or other means use of or disclosure of any part thereof is strictly prohibited Eurekify reserves the right to make changes to specifications at any time without prior notice The information furnished in this document by Eurekify is presumed to be accurate and reliable at time of publication but Eurekify takes no responsibility whatsoever for the consequences of its use Information in this manual is subject to change without notice No part of this publication may be reproduced or distributed in any form or by any means electronic or mechanical for any purpose without the express written permission of Eurekify Ltd TRADEMARKS Eurekify and Sage are registered trademarks of Eurekify Ltd All other products or services referred to in this manual are the trademarks service marks or product names of their respective holders DISCLAIMER The products and specifications configurations and other technical information regarding the products contained in this manual are subject to change without notice All the statements technical informatio
53. evelopment Angel Ben System Management Corporate 0 13 10 18 Atek Rogers Fifth Ave Branch Branches 0 5 4 4 Bean Frank Purchasing Corporate 0 7 4 4 Bell Kim Marketing_Dept Corporate 0 5 4 4 Bizman Michelle Application Corporate 0 4 4 4 Development 98732770 Brazil Bill Application Corporate 0 6 3 3 Development 98383830 Capel Linda Application Corporate D 10 5 5 Development 89753140 Cherry Jay Finance Corporate 0 14 9 13 75464420 Cohen Steve System Management Corporate 0 6 5 5 54672910 Cooper Amos IT Security Corporate D 5 4 5 75675330 Davis Brett Database Corporate D 8 6 8 Administrators 91238730 Deer Alex Fifth Ave Branch Branches 5 4 4 88382990 Devin Roger Marketing Dept D 6 6 6 89653230 Doll Charles Database Corporate 6 6 6 Administrators 76329130 Eagle Richard Fifth Ave Branch Branches 0 d 7 7 95477810 Ester Roger Operations Corporate D 5 4 4 84848110 Fidelity Bob Operations Corporate 0 9 6 6 91236370 Flag Lee IT Security Corporate 0 4 3 4 86544420 Fred John System Management Corporate O 13 10 18 93833870 Free Georgia Marketing_Dept Corporate O 4 77371120 Garr Jim Marketing_Dept Corporate 0 7 5 94738470 German Tom Fifth Ave Branch Branches 7 7 7 89123140 Godheart Dan IT Security Corporate 0 4 3 4 84847310 Goid Wiliam Human Resources Corporate hh 4 4 88311130 Goodman Bruce Marketing Dept Corporate 9 8 8 88261730 Green Richard Human Resources Corporate 2 d 1 83838380 Helmuth Howard Marketing Dept Corporate 8 5 5 64646410
54. ge edit the values for the Connection String You need to supply the Server Name as the value for the Data Source Database Name as the value for the Initial Catalog Select the Windows Integrated Security option A Report Manager Microsoft Internet Explorer EER File Edit View Favorites Tools Help Q ex c x a Ja Search She Favorites o R 2 jw gt m a 3 host Reports P E Be Links gt Home My Subscriptions Site Settings Help ss E http localhost Reports Pages DataSource aspx ItemPath 2fSageReports 2f5DB SQL Server Reporting Services Home gt SageReports gt Search for so SDB Dependent Items Subscriptions Name General Security Description Hide in list view V Enable this data source Connection type Microsoft SQL Server Connection string Fe TAS Connect using Ocredentials supplied by the user running the report amp http flocalhost Reports en help f1_rsc_webui_standalone_Ssvf htm 3 Local intranet Figure 14 SDB Connection String Options Page 12 Version 3 1 Eurekify SageReports 1 5 Exporting reports to other formats After generating reports they can be exported to a variety of formats to aid in distribution and use of the information Amongst others these formats include PDF Excel and TIFF file formats The available export formats vary according to the version of Microsoft Reporting Services that yo
55. ge biscovery amp Audit Figure 27 Configuration Roles Full Report Page 28 SageReports Version 3 1 Eurekify SageReports 2 2 2 2 1 Version 3 1 Users and Resources Reports Database Users Report General Lists some all of a database s users one per line Parameters Users Database By Field Which user field to choose users by From To Choose a range of values or leave empty for all Pattern Show only users who match a pattern 26 10 Database Users Report Database UsersDB By Field PersonID From Pattern Organiz tion Org Type Country Location 45489940 Steiven Pat System Management Corporate us Pennsylvania Moris Bill em Management Corporate us Pennsylvania Rodman Adam System Management US Pennsylvania ooper Amos IT urity Us Pennsylvania Alex Patrick Application Development Pennsylvania Miles Buyer Purchasing New Jers Operations Corporate us New Jersi Pheonix William Application Development Corporate Us Pennsylvania Angel Ben System Management Corporate U New Jer warts Barry Human Resources Corporate US New Jer Purple Mary Fifth Ave Branch Branct us New vork Lu marry Peter Stamford Branch Branches Connecticut Management Pennsylv Admini Pennsyl Administrators Corpora Us Pennsylvania Eagle Richard Fifth Ave Br Branches US New York Redhead Richard System Management Corporate Pennsylvania Keren Cindy Applica
56. guration gt 5 Configure the datasource to use stored credentials Microsoft Reporting Services subscriptions feature reguires the credentials to the datasource to be stored 6 Click the SDB link in Reports Manager and choose Credentials stored securely in the report server 7 Fill in a valid login to the SOL server This login can be either a Windows Authentication login or a SOL Server login It is recommended that your SOL Server will support both methods Go to Enterprise Manager click on your server Go to server properties security tab check the SOL Server and Windows authentication Note this login will be used by the report server for accessing the SOL server to produce reports This is separate from the login report that users fill in to access the report server Page 82 Version 3 1 Eurekify E Report Manager Microsoft Internet Explorer File Edit View Favorites Tools Help Q sek cJ x E JO search SLC Favorites D B 2 zi gt ln rel Address 2 http flocalhost Reports Pages DataSource aspx ItemPath 2fSageReports 2F5DB Links amp Report Manager B Reporting Services Google G Search G g Sizblocked F Check X Autolink v Enable this data source Connection Type Microsoft SQL Server Connection String data source local initial catalog devRSSage Connect Using OThe credentials supplied by the user running the report 9 C
57. hin subject or functional categories to provide easy access to specific reports This chapter provides a general overview of subscribing to reports and details the preparations that need to be made to the machine that hosts the reports server in order to support report subscription 3 1 General Overview Subscriptions enable users to receive reports automatically in addition to running reports on demand Each SageReports user can choose which reports he she would like to receive as well as how by e mail or a shared file server and when specify a schedule 3 2 Preparations Prior to using subscriptions preparations need be made on the report server the machine that hosts MS Reporting Services You must instruct Reporting Services as to which SMTP server to use for sending emails This is performed in the default location for Reporting Services C Program Files Microsoft SQL Server MSSQL Reporting Services ReportServer Version 3 1 Page 81 Eurekify SageReports To instruct MS Reporting Services 1 Go to the default location for Reporting Services as indicated above 2 Edit the file RSReportServer config file 3 Look for the xml field lt SMTPServer gt and change the xml value to that of your SMTP server URL 4 Enter the From email in the lt From gt field Note Currently RS doesn t support sending emails to smtp servers which require authentication RSReportServer config Notepad File Edit Format View H
58. ile called LogoCustomer bmp and is located on the machine where Eurekify Sage Reports is installed under the following directory C Program Files Eurekify SageReports V3 0 Reports To change the customer logo 1 2 3 Go to directory C Program Files Eurekify Eurekify Sage Reports V3 0 Reports Rename the original LogoCustomer bmp file to LogoCustomer org bmp Save your desired logo as a BMP file named LogoCustomer bmp Copy it to C Program Files EurekifNEurekify Sage Reports V3 0 Reports Go to directory C Program Files Eurekify Eurekify Sage Reports V3 0N Execute the script InstallCustomerLogo bat ex file C DOCUME 1 ILANSH 1 LOCALS 1 Temp tb581unq exe C NProgram Files Eurekif y SageReports U2 C Program Files Eurekif y SageReports U2 OE EE bat C Program Files Eurekif y SageReports U2 8 gt echo off The command completed successfully Press any key to continue m Figure 16 Installing Customer Logo Upon successful completion the Sage Reports are ready and display with the new logo Page 14 Version 3 1 Eurekify 1 7 Troubleshooting This section identifies a series of problems that may occur when installing or working with Sage Reports and lists treatments for dealing with the problems SageReports Problem Area Error or Message Treatment Sage Reports Cannot find file or similar Make sure you have RS exe and osql exe on your reports Fail
59. installed the Sage Portal Client is easily accessed from the Programs folder Version 3 1 Page 9 Eurekify SageReports To view reports via the Sage Portal Client applicatoin 1 Select Start gt All Programs gt Eurekify Sage ERM gt Eurekify Sage Portal Client The client opens on your desktop 2 Either click the Reports icon in the body of the window or the Reports button from the menu bar at the top of the window the Reports page opens Report categories are displayed in the left pane of the window The remainder of the window serves to display this list of reports available for a given category Sage Portal eure If y me enterprise note Management company Data Management Sage DNA Workstation Reports M Select Reports Folder to Display Figure 11 Reports window from with Sage Portal Client Application 3 From this point on viewing and interacting with reports is performed as described for Viewing reports via the Sage Portal in section 1 4 1 1 4 3 Viewing Reports via Microsoft Reporting Services In general viewing reports via Microsoft Reporting Services serves the purposes of verifying that the Sage Reports were correctly installed This environment should be used by the systems administrator or other personnel that install the application There are two other occasions when using the Microsoft GUI is reguired Changing the connection parameters associated with the Sage Reports Datasource Working from within
60. iption 11 7 2005 File 01 Configuratior WeurekifyeyalShare as 9 17 AM Properties Report pdf 01 Configuration was written to Properties Report WMeurekifyeyalShare w gt 3 Local intranet For more information about subscriptions click the following link http msdn microsoft com library default asp url library en us rswork htm rms subscribing vl 3d68 asp Version 3 1 Page 87
61. is average score V2 std Prerequisites AuditCard which has the following alerts selected Tab Suspect Entities User Collectors Resources Collectibles Suspect Connections User Resource Entities with many few connections Users with Resources with Version 3 1 Page 43 Eurekify SageReports Users and Resources Analysis Report PAR AuditCarc WIthRoles3Audit 1 Config ConfigwithRol Validation Fa Users Analysis Category Users Percent Users with Few 1 1 Suspected Collectors 2 3 Suspected Connections 6 9 96 58 87 96 67 100 96 87 1 3 9 Resources Analysis Category Resources Percent Res with Few Priviliges 21 25 Suspected Collectibles 3 4 Suspected Connections 14 13 96 48 58 96 83 100 96 13 25 4 eurefity Sage Discovery amp Audit Sage Discovery amp Audit Figure 41 Users and Resources Analysis Report Page 44 Version 3 1 Eurekify SageReports 2 4 5 Suspected Collectors Users General This report keeps track of the suspected collectors that appear in the given AuditCard including how many alerts there are in each severity based on the alert s score with a pie chart and a list of the top 10 collectors Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Entities Checkb
62. le Direct Res Person ID Organization Country Title Direct Res Person ID Organization Country Title Direct Res Person ID Organization Country Title Direct Res Config ConfigWIthRoles3 From Alex Patrick To Maor Kathy 57644540 Application Development US Developer Total Res 67283470 System Management US Developer Total Res 87623490 Fifth Ave Branch US Branch Officer Clerk 99883110 Purchasing US Purchasing Officer Total Res 87635420 Marketing_Dept US Secretary Total Res Configuration Users Detailed Report By Field UserName Pattern User Name 26 10 2005 12 45 Sort Ascending Alex Patrick Organization Type Corporate Location Cost Center Direct Roles User Name Pennsylvania 30111 Total Roles Angel Ben Organization Type Corporate Location Cost Center Direct Roles User Name Organization Type Location Cost Center Direct Roles User Name Organization Type Location Cost Center Direct Roles User Name Organization Type Location Cost Center New Jersey 24123 Total Roles Atek Rogers Branches New York 22321 Total Roles Bean Frank Corporate New Jersey 32444 Total Roles Bell Kim Corporate New Jersey 25331 Total Roles Page 1 of 8 eure Kify Sage biscovery 8 Audit Sage biscovery amp Audit Figure 20 Configuration Users Detailed Report Page 21 Eurekify SageReports
63. lling Sage Reports you MUST have A machine with Windows XP or Windows 2000 2003 Server NET framework 1 1 or higher Internet Information Services IIS 5 0 or higher SQL Server of one of the following versions e SQL Server 2000 Full version not MSDE e SQL Server 2000 Service Pack 4 or higher e SQL Server 2005 Requires NET 2 0 e SQL Server 2005 Express Editions with Advanced Features SQL Reporting Services SQL Reporting Services Service Pack 2 For further details check the Eurekify Sage Enterprise Role Management Installation Guide provided as part of the documentation set Version 3 1 Page 1 Eurekify SageReports Tips Enable IIS from Control Panel gt Add Remove Programs gt Add Remove windows components To install ASP NET download the file dotnetfx exe from Microsoft s web site Install the SQL Server 2000 version Enterprise Standard Developer that suits your platform Windows XP 2000 Before installing SageReports verify that Reporting Services is functioning go to http localhost reports You should see a similar page as shown below a Report Manager Microsoft Internet Explorer Jog File Edt View Favorites Tools Help a Oes i3 a JO Search she Favorites OR x Address http flocalhost reports Pages Folder aspx Eo us Home My Subscriptions Site Settings Help ca va Reporting Services GESE ES Cu New Folder Ne
64. luding each role s resources and users Configuration Roles Full Report Parameters Configuration By Field Which resource field to choose users by From To Choose a range of values or leave empty for all Pattern Show only resources that match a pattern Configuration Roles Full Report Config igWIthRoles3 R eName From AD RL To BSAVESYS Role ADMGNRL Role ID 1150 Role Name ADMGNRL Description Organization IT Users Count 10 26 10 2005 12 10 ending User ID Person ID User Name Organiz tion F Organization Type 5 58723810 Miles Buyer Purchasing Corporate 9 67565330 Schwarts Barry Human Resources Corporate 18 77371120 Garr Jim Marketing_Dept Corporate 21 83838380 Helmuth Howard Marketing Dept Corporate 23 84847310 Goid Wiliam Human Resources Corporate 35 87635420 Bell Kim Marketing_Dept Corporate 37 88311130 Goodman Bruce Marketing_Dept Corporate 38 88382990 Devin Roger Marketing_Dept Corporate 51 93833870 Free Georgia Marketing_Dept Corporate 65 99883110 Bean Frank Purchasing Corporate Direct Resources Resources count 1 Resource Res name 1 Res name 2 Res name 3 Owner UGADGEN1 4d NOVELADM Novell4 ADMNLAN ministration ROOT Indirect Resources Direct P rent Roles Sub Roles Roles count 1 Role T Role Description 1106 SECMGR Sage Role Role ID Name Organization Client Logo eure ify B Page 1 of 11 Sage Discovery amp Audit Sa
65. n and recommendations contained in this manual are believed to be accurate and reliable but are presented without warranty of any kind and users must take full responsibility for the application of any products specified in this manual IN NO EVENT SHALL EUREKIFY OR ITS SUPPLIERS BE LIABLE FOR ANY INDIRECT SPECIAL CONSEQUENTIAL OR INCIDENTAL DAMAGES INCLUDING WITHOUT LIMITATION LOST PROFITS OR LOSS OR DAMAGE TO DATA ARISING OUT OF THE USE OR INABILITY TO USE THIS MANUAL EVEN IF EUREKIFY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES Publication History 0003 Sage Reports User Manual Febtuary 2007 User Manual Ver 3 1 Contents PREFACE eeuse see sesse see sesse see see se See be ee See Bee SEE Be Ee See BEE Ee ee SEE Be Ee Ee ee Ee ee Ee ee ee ee VII About This Mantal teh ee ee meet e me Pee eee vii Who Should Use This Manual se se ee Re ee nennen vii Document Conventions SOR EE en E ee viii Contact Information tape vate optet ot PE Ce ero ends viii CHAPTER 1 GENERAL BACKGROUND eerte eene nentes ese ese see see See tne 1 l l Prerequisi s uet endete HRS UR RR D ids 1 1 2 Installing Sage Reports oed rere gie epe sakiet 3 1 3 Introducing the RepOTtS i e ese see ke ke ee rennen ee ke ke renes 6 1 4 Viewing Reports seska eee eere e ec ie SE De ee DR GE seke 7 1 41 Viewing reports via the Sage Portal s 7 142 Viewing Reports via the Sage Portal Cli
66. n Report 11 13 2006 2 37 PM Master Configuration Configuration No Roles ZIEMA 429 ConfigNoRoles Role Di Confi A CNR Iterated CC Config Noftoles_iterated 59 88 06 CNR Organization Taa AIM IE REY ConfigNoRoles by org CNR Title ae aa ada am Config Noftoles_by_ttie Figure 49 Role Engineering Methodologies Comparison 2 4 16 Overlapping Roles by Users Report Version 3 1 General A Survey report Shows how many roles have overlapping users divided into 3 levels of overlap Parameters Configuration AuditCard Page 61 Eurekify SageReports High the percentage of overlapping users used as the high threshold Med Low Similarly Prereguisites AuditCard which has the following alerts selected Tab Similar Roles and role hierarchy Roles covering same users Roles covering same resources Entities with many few connections Users with Resources with Overlapping Roles by Users Report Configuration ConfigWIthRoles3 AuditCard ConfigWIthRoles3Audit1 Overlapping Roles by Users Overlapping 100 Overlapping 90 1 Ding 7 14 OK 37 Total Roles 96 Top 10 Suspects Role Name Role Description Role Organization Score Org tion Human Charact 100 es ADMHR Sage Role IT 100 Characteristic Role 8096 100 IT 100 g Characteristic Role 80 100 Purchasing ADMPUR IT 100 Silicon Charact 100 ch IT 100 Organizati
67. ntry US Location Cayman Auditor Cost Center 28777 Resources Info Roles Info User 98383770 Rolen Dave Person ID 98383770 user name Dave Organiz tion Finance Organization Type Corporate Country Us Loc tion Cayman Title Accountant Cost Center 28777 Resources Info Roles Info Client Logo EER eureKify Sage Discovery 8 Audit Sage Discovery 8 Audit Figure 56 Users Certification Report by Category Page 72 Version 3 1 Eurekify SageReports 2 7 3 Users Privileges Recertification Report Full Version 3 1 General Reports the differences between two configurations in terms of User Privileges their Roles and Resources based on a selected Category for instance Organization The report can take into consideration alerts listed in an Audit card Parameters Old Configuration Current Configuration Current Audit Card Category From To choose range User Privileges Recertification Report 3 13 2006 11 39 AM Old Configuration ConfigNoRoles Current Configuration ConfigNoRoles_by_org Category Organization From Fifth Ave Branch To Fifth Ave Branch Common Category Fifth Ave Branch 10 Common Users 67762440 Purple Mary Fifth Ave Branch Branches Roles Info Roles Added 1 GR Organization Fifth Ave Characteristic Role 100 0 Suspected 27 Branch Min 60 No Roles Removed Resources Info No Resource Added Resources Removed 7 UGSAVEGEN NTSAVE WinNT UGSAVELAN NTSAVE WinNT
68. on System Charact 100 Management SYSGNRL Sage Role IT 100 lient L Client ogo Page 1 of1 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 50 Overlapping Roles by Users Report Page 62 Version 3 1 Eurekify SageReports 2 4 17 Overlapping Roles by Resources Report General A Survey report Shows how many roles have overlapping resources divided into 3 levels of overlap Version 3 1 Parameters Configuration AuditCard High the percentage of overlapping resources used as the high threshold Med Low Similarly Prerequisites AuditCard which has the following alerts selected Tab Similar Roles and role hierarchy Roles covering same users Roles covering same resources Entities with many few connections Users with Resources with Page 63 Eurekify SageReports Overlapping Roles by Resources Report 26 10 2005 Configuration ConfigWIthRoles3 AuditCard ConfigWIthRoles3Audit1 Overlapping Roles by Resources By Resources Overlapping 100 Overlapping 90 OK Total Roles 9 10 4 Top 10 Suspects Role ee Role Organization Organization Characteristic Role 80 100 Database Administrators Organization Characteristic Role 80 100 Application Development Organization IT Characteristic Role 80 100 Security SECMGR Sage Role IT 100 Organization Characteristic Role 80 100 Operations OPERJ2 Sage Role IT 100
69. ons Dual Role Role esee 60 2 4 15 Role Engineering Methodologies Comparison Report 61 2 4 16 Overlapping Roles by Users Report esses 61 2 4 17 Overlapping Roles by Resources Report eese 63 2 5 Role Engineering Repor Soan onien ennea a een oo aa aa 65 2 3 Role Analysis Report somi see ss aaa Ge be ER SE ER 65 2 5 2 Role Approval Status Report a 67 2 5 3 Users Role Base Privileges 1 sess 68 2 5 4 Role Engineering Methodologies Comparison sess 68 2 6 Role Maintenance Report siese se se ee ee ee ee ee ke ke ke Ad nennen 69 2 6 1 Role Approval Status Report iese a 69 2 6 2 Role Approval Report 69 2 6 3 Role Reapproval Report as 69 2 6 4 Overlapping Roles by Users aaa 69 2 6 5 Overlapping Roles by Resources essere 69 2 7 Privileges Certification Reports ahada aaa 70 2 7 1 Users Change Certification Report eese 70 2 7 2 Users Privileges Certification Report sess 71 2 7 3 Users Privileges Recertification Report Full sss 73 2 7 4 Users Role Privileges Recertification Report 74 2 7 5 Users Privileges Change Request Report essen 75 2 7 6 Certification Progress Status Report 75 2 7 7 Role Approval Report as 76 2 7 8 Role Reapproval Report nennen eene 76 2 79 Role User Membership Reapproval Report
70. operties aspx CreateNew True amp Isl xi kd co Links E Report Manager O Reporting Services i sl IG Search O g Bizblocked When the scheduled report run is complete Select Schedule At 8 00 AM every Mon of every week starting 11 7 2005 Report Parameter Values Specify the report parameter values to use with this subscription Config ConfiawIthRoles3 J Local intranet 7 Click OK to save the subscription Page 86 Version 3 1 Eurekify 8 SageReports To view current subscriptions and for reports and their status click on subscriptions a Report Manager Microsoft Internet Explorer DER File Edit View Favorites Tools Help aw Q ex Q ix a x Search sip Favorites B Z jw gt LJ el Address gl http flocalhost Reports Pages Report aspx ItemPath Ys2fSageReportsYs2fConfiguration ReportsYo v a8 Go Links amp Report Manager ae Reporting Services Google v IG search O g Sizblocked F Check rk Autolink gt SOL Server Reporting Services Home My Subscriptions Site Settings Home gt SageReports gt Configuration He Reports gt li 01 Configuration IA Properties Report KSM Properties History X Delete New Subscription New Data driven Subscription Description Trigger Last Run Status 3 Edit Send e mail to TimedSubscription 11 7 2005 Mail sent to sacharov eyal idc ac il 9 10 AM sacharov eyal idc ar A Edit Save in TimedSubscr
71. ources in addition to various data from AuditCard proposed new users almost matching users and almost matching resources In addition the report groups the roles by a chosen role category for instance RoleOrganization and presents group statistics for each value in the category Parameters Configuration Role Category From To choose range Pattern Show Users Resources Roles Whether to show each role s users resources and parent sub roles Show group users resources Whether to show each group s users and resources AuditCard Show alerts from AuditCard From To status choose which approval status to show Prerequisites AuditCard which has the following alerts selected Tab In Out of pattern entities check all the boxes Page 76 Version 3 1 SageReports Eurekify Roles Certification Report by Role Category 07 12 2005 06 39 Config Config WIthR oles3 By Field Role Organization From New Org Pattern Role UCISUSER New Role Iterated Organization New Org New Owner Eyal Pre approved Ap 12 7 2005 3 24 00 PM Users Info Direct Users Users count 3 Person D User Name B7347830 Mike Pamela Application Development Corporate 88311130 Goodman Bruce Marketing Dept Corporate 88382990 Devin Roger Marketing Dept Corporate Dual Users Nane Indirect Users None Almost Matching Users Users count 3 Person ID Organization
72. owed to Have lt R gt Cherry Jay 89753140 CAYMAN 8 30 2006 Finance Cayman Onske 1 People in Cayman are only allowed to these roles Cherry Jay 89753140 8 30 2006 Finance Cayman Onsite 1 People in Cayman are only allowed to these roles Cherry Jay 89753140 8 30 2006 Finance Cayman Onske 1 People In Cayman are only allowed to these roles Cherry Jay 89753140 8 30 2006 Finanoe Cayman Onste 1 People in Cayman are only allowed to these roles Cherry Jay 89753140 8 30 2006 Finance Cayman Onske 1 People in Cayman are only allowed to these roles e Client Logo ein eurekify Sage Discovery amp Audit Sage Discovery amp Audit Figure 35 Audit Card Alerts by Type Group Page 36 Version 3 1 Eurekify SageReports 2 3 5 Version 3 1 Policy Verification Report General A report that displays the violations of each rule for a given Sage Policy Parameters Configuration Audit Card Sage Policy Policy Verification Report Config ConfigWithRoles Policy BankPolicy GIET FT TA Finance Cayman Onsite 2 _ Aud tCard ConfigWithRolesAudit1 a 1 2018 People in Cayman must be in this role BPR Role Role lt L gt Must Have lt R gt Left Entities CAYMAN CAYMAN GOOGLEU Finance Cayman Onsite 3 Right Entities Violations la sials And only people in Cayman are allowed in this role BPR Role Role Only lt L gt May Have lt R gt Left Entities CAYMAN Right En
73. oxes Users Collectors Version 3 1 Page 45 Eurekify SageReports Suspected Collectors Users PA Config ConfigWIthRoles3 AuditCard ConfigWIthRoles3Audit1 Score Threshold Users Me Total Alerts in AuditCard 63 Kd very Low Under 253 Total Users in Configuration 67 Average Score 253 STDEV 92 93 3 0 1 5 1 5 Top 10 Suspects PersonID User Name Organiz tion Organization Type Score 45489940 Steiven Pat System Management Corporate 381 89753140 Cherry Jay Finance Corporate 262 98383830 Capel Linda Application Development Corporate 190 64646410 Herman Barbara Operations Corporate 179 Page 1 of 1 eure ify Sage biscovery amp Audit Sage Discovery amp Audit Figure 42 Suspected Collectors Users Page 46 Version 3 1 Eurekify SageReports 2 4 6 Suspected Collectible Resources General This report keeps track of the suspected collectible resources that appear in the given AuditCard including how many alerts are there in each severity based on the alert s score with a pie chart and a list of the top 10 collectibles Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Entities Checkboxes Resources Collectibles Version 3 1 Page 47 Eurekify SageReports Suspected Collectibles Resources um
74. redentials stored securely in the report server User name s Password oeoooooe use as Windows credentials when connecting to the data source If you enter a Windows login not SOL Server login then check this box Local intranet SageReports 10 Enable scheduling For the reports to run the scheduling service has to be started 11 Goto Administrative Tools gt Services and Start the service SOLSER VERAGENT EIER File Action View Help gt R Em Services Local SOLSERVERAGENT Mame Description Status Sis Server Supports fil Started Stop the service Sy Shell Hardware Det Started Restart the service Services Local Sy Simple Mail Transfer Transports Started Sy Smart Card Manages a A SOL Browser Provides 5 Basar Server SOLEX Microsoft Started Sis SSDP Discovery Ser Enables Sis Symantec Core LC Symantec Stop Sy Symantec Event Ma Symantec Sy Symantec Network Symantec SE Symantec Password Symantec Restart By symantec Settings Symantec All Tasks gt By Symantec SPBBCSvc Symantec a Refresh Extended A Standard Properties Start service SQLSERVERAGENT on Local Computer Help Version 3 1 Page 83 Eurekify SageReports After the above steps are completed a button New Subscription will appear above each report File Edit View Favorites Tools Help
75. rt Version 3 1 Page 59 Eurekify SageReports 2 4 14 Suspected Connections Dual Role Role General This report keeps track of the dual links between parent roles and child roles in the given AuditCard It shows all top 10 of the connections parent roles and child roles involved in dual links Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes User Resource Dual Links This Report is similar to the previous report Page 60 Version 3 1 Eurekify SageReports 2 4 15 Role Engineering Methodologies Comparison Report General A Survey report Compares the Roles Users Resources and Privileges data derived from different methods of role discovery Each discovery method produces a separate Role Discovery Configuration that is used as input for the report Parameters Master Configuration used as the base for producing various Role Discovery Configurations Each Role Discovery Configurations based on a separate discovery method Labels provide a name or header for one or more configurations that are included in the report To group a set of configurations under a single heading in the report provide the same label for each configuration you want to include in the group Role Engineering Methodologies Compariso
76. sers Covered By Another 99 360 0 0 0 360 0 92 Role Sutsumad By Another Sama Resources 7 18 0 0 J 18 0 0 36 Client Logo eure eif Page 1 of 2 Sage Discovery amp Audit Sage Discovery amp Audit Figure 34 AuditCard Properties Report Version 3 1 Page 35 Eurekify SageReports 2 3 4 AuditCard Alerts by Type Group General A report that displays some all of the alerts in the given AuditCard by Type Group according to the given parameters Parameters Configuration Audit Card Group Type AuditCard Alerts by Type Group Report 5 12 2026 3 36 23 PM Config ConfigwithRoles _ Aud tcard Config WithRolesAuditi ype Group Business Process TS ee BPR Rols Role Only lt L gt May Have lt R gt Maor Kathy 98383840 CAYMAN 0 Suspected 8 30 2006 Finance Cayman Onsite 3 And only people In Cayman are allowed In this role BPR Rols Role lt L gt Must Have lt R gt Cherry Jay 89753140 CAYMAN 8 30 2006 Finance Cayman Onste 2 People in Cayman must be in this role BPR Role Role lt L gt Forbidden to Have lt R gt Hape Collin 91724340 CAYMAN 8 30 2006 Finance Cayman Onske 4 This i5 not consistent with previous assertions More Cathrine 97774230 CAYMAN 8 30 2006 Finance Cayman Onste 4 This amp not consistent with previous assertions Rolen Dave 98383770 CAYMAN 8 30 2006 Finance Cayman Onske 4 This ts not coesistent with previous assertions BPR Rols Role lt L gt Only All
77. sing Corporate 9 67565330 Schwarts Barry Human Resources Corporate 18 77371120 Garr Jim Marketing Dept Corporate 21 83838380 Helmuth Howard Marketing_Dept Corporate 23 84847310 Goid Wiliam Human Resources Corporate 35 87635420 Bell Kim Marketing_Dept Corporate 27 88311130 Goodman Bruce Marketing Dept Corporate 38 88382990 Devin Roger Marketing Dept Corporate 51 93833870 Free Georgia Marketing Dept Corporate 65 99883110 Bean Frank Purchasing Corporate Indirect Users Users count 0 User Name User ID Person ID Organization Organization Type j 54672910 Cooper Amos IT Security Corporate 89123140 Godheart Dan IT Security Corporate 89213720 Orr Taylor IT Security Corporate 91236370 Flag Lee IT Security Corporate Dual Users Users count 1 Person ID User Name Organization Organization Type 54672910 IT Security Cooper Amos Corporate Client Logo eurekify Sage biscovery amp Audit Sage Discovery amp Audit Figure 52 Role Analysis Report Page 66 Version 3 1 Eurekify 2 5 2 SageReports Role Approval Status Report General Shows the roles grouped by a chosen role attribute for instance RoleReviewer divided to each approval status including pie charts that show how many roles are in each approval status Parameters Configuration Group by which field to group by From To range Pattern UGSA 4 Rol
78. t PersonID User Name Role Name Score 87368000 Toper Jim Title Branch Officer Clerk 51 87368000 Toper Jim B5AVEJ1 51 98383830 Capel Linda Organization Application 45 Development 82922230 Levi Jay STAMFORD 38 97373330 Katz Nancy TSSIEVJT 36 98383830 Capel Linda DEV MF 36 97373330 Katz Nancy BSILVJ1 36 97373330 Katz Nancy Organization Silicon Valley Branch 36 98383830 Capel Linda Development 36 98383840 Maor Kathy Title Accountant 36 Page 1 of 1 eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 46 Suspected Connections User Role Page 54 Version 3 1 Eurekify SageReports 2 4 10 Suspected Connections Role Resource General This report keeps track of the suspected role resource connections that appear in the given AuditCard including how many alerts are there in each severity based on the alert s score with a pie chart and a list of the top 10 suspected connections Parameters Configuration AuditCard see prerequisites Very Low Low Med High These are the severity thresholds Prerequisites AuditCard which has the following alerts selected Tab Suspect Connections Checkboxes Role Resource Connections Version 3 1 Page 55 Eurekify SageReports Config ConfigWIthRoles3 OK No Alerts Very Low Under 38 Low 38 42 49 Med 42 49 46 98 High 46 98 51 47 Very High Over 51 47 co Alerts Very Low Low Med High Very High Susp
79. tails 4 SageReports new E amp J Local intranet Figure 5 Sage Reports Home Page Now click on the SageReports icon to open the SageReports folder and view the report types Z Report Manager Microsoft Internet Explorer DAR File Edit View Favorites Tools Help ay Q ex Q x a JP Search ST Favorites C EP p jw LJ rel 33 c Address E http slocalhost Reports Pages Folder aspx ItemPath 2FSageReparts amp viewMade List 1 SE Links gt m Home My Subscriptions Site Settings Hel SQL Server Reporting Services l Help m Lid Home gt Search for SageReports Ci New Folder New Data Source Upload File 3 Report Builder Show Details E About SageReports new 2 Privileges Certification Reports NEW m Auditing and Compliance Reports new E Role Engineering Reports new d Configuration Reports new C3 Role Maintenance Reports new i Custom Reports new SDB NEW m Database Reports new L3 Survey Reports new E http localhost Reports Pages Settings aspx 3 Local intranet Figure 6 Sage Reports At this point the reports are all empty Reports can only be generated from Configuration and Audit files that have previously been saved to the database So to generate a report you must first open a configuration file in Sage DNA and Save to Database Page 6 Version 3 1 Eurekify SageReports 1 4 Viewing Reports The reports are divided into several folders accor
80. ther than when you have multiple installations Installation Setting Default Value Database Name DB Name sdb SQL Server Name Report Server URL http localhost reportserver Page 3 Eurekify SageReports Installation Setting Default Value Web Folder Name Sage Reports 5 Click Next The Overwrite Reports step appears Select Overwrite if you do not have any previous reports or if you intend to discard all previous reports Select Do Not Overwrite to keep all existing reports is Eurekify Sage Reports V3 0 C ni Overwrite Reports Do you want to overwrite existing reports Overwrite O Do Not Overwrite 6 Click Next and the Select Installation Folder step appears By default the Sage Reports Folder is placed in the Installation Drive gt lt Installation Folder gt Click the Browse button and navigate to the folder of your choice to choose an alternate installation folder Click Disk Cost to view a list of disk drives and available space on each drive Page 4 Version 3 1 Eurekify SageReports Hok Select Installation Folder eure afy il Eurekify Sage Reports V3 0 The installer will install Eurekify Sage Reports V3 0 to the following folder To install in this folder click Next To install to a different folder enter it below or click Browse Eolder C Program FilesEurekifyE urekify Sage Reports V3 0 Install Eurekify Sage Reports
81. thin the Sage Portal 1 These modules serve the purposes of role engineers and are accessed from the Sage Portal Client application Version 3 1 Page 7 Eurekify SageReports To view reports via the Sage Portal 1 Open the Microsoft Explorer browser 2 Enter the URL http localhost sageportal The Sage Portal opens to the home page 7 Sage Portal Microsoft Internet Explorer DEAR Fle Edt Ven Favortes Tools Heb O O HAG Da Km O BS LIE 3x Address 8 http localhost sageportal v Eco we eure ity N Sage DNA Workstation M unknown Zone Mixed Figure 7 Sage Portal home page 3 Either click the Reports icon in the body of the page or the Reports button from the menu bar at the top of the page the Reports page opens Report categories are displayed in the left pane of the window The remainder of the window serves to display this list of reports available for a given category 4 Click a category folder to display the list of reports Z Sage Portal Microsoft Internet Explorer DER Fie Edt View Favorites Tools Help EJ O O HAO De dem 6 0 3 HAS Address 48 http ocstok ssgepotli v oe Links 7 EUTEKI Y me enterprise Role Management Company Data Management Sage DNA Workstation Business collaboration a Sh E unknown Zone Mixed Figure 8 List of Reports Page 8 Version 3 1 Eurekify 5 6 1 4 2 SageReports Click a Report from the list An empty report win
82. tion Development Corporate Pennsylvania Garr Jim Marketing_Dept Corporate New Jersey Hill Gary Fifth Ave Branch Bran US New York Levi Jay Stamford Branch Bran US Connecticut Helmuth Ho Marketing_Dept Corporate us New Mills Robert Fifth Ave Branch US New Yo Goid Wiliarn Human Resources Corporate US New Fidelity Bob Operations Corporate US New Sterling Kent Human Resources Corporate US New J Stahlman Human Resources Corporate Us New J Michael Bizman Michelle Application Dev Pennsylvania Fred John System Management Pennsylvania Mike Pamela Application Development Corporate Pennsylvania Toper Jim Stamford Branch Branches Connecticut Saven Werner Fifth Ave Branch Branches New York Wear Isabelle Stamford Branch Branches US Connecticut Moos Human Resources Corporate New Jersey Atek Rogers Fifth Ave Branch Branches US New York Bell Kirn Corporate US New Jer Green Richard US New Jer Goodman Bruce Marketing_Dept Corporate us New Jersey Client Logo matat eure ify Sage biscovery 8 Audit Sage biscovery amp Audit Figure 28 Database Users Report Page 29 Eurekify SageReports 2 2 2 Database Users Detailed Report General Lists some all of a database s users including ALL user fields Parameters Users Database By Field Which user field to choose users by From To Choose a range of values or leave empty for all Pattern Show only users who match a
83. tities TSFIN1 Violations First Ent ty Second Entity Third Entity Hope Collin 91724340 CAYMAN More Cathrine 97774230 CAYMAN Rolen Dave 98383770 CAYMAN LIES ETS Role Mar 1 Ju Just a test of role resource Left Entities Client Logo Sage Discovery amp Audit Figure 36 Suspected Right Entities Suspected Suspected Suspected restriction BPR Role Resource Only lt L gt May Have lt R gt Right Entities UGFINMGR TSSCREDIT Violations TSS50 9 10 2006 3 59 17 PM 30 2006 8 30 2006 8 30 2006 8 30 2006 8 30 2006 None Page 3 of 7 eure ify Sage Discovery amp Audit Policy Verification Report Page 37 Eurekify SageReports 2 3 6 Sage Policy Status Report General A report that displays the percentage of violations for each rule in a given policy Parameters Configuration Audit Card Sage Policy Sage Policy Status Report 9 10 2006 4 29 16 PM nfigWithRolesA Sage Policy BankPolicy BPR Role Resource L Must Have R HR 1 HR people must have access to this resource Role Mgr 2 role resource 2 BPR Role Role Only lt L gt May Have lt R gt Geo Stamford Roles limited to this branch Finance Cayman And only people in Cayman are allowed Onsite 3 role BPR Segregation of Duty Roles No More Dev Seg of Duty One person is not allowed on teams that develop in different computing environments
84. u have installed Ed oe Find Next Select a format Export A 3 Select a format HTML with Office web Components Excel Web archive PDF file cro TIFF file CSV comma delimited s for ConfigWithRoles XML file with report data 59 81 Figure 15 Exporting Files in Various Formats To export a report to another format 1 Select the desired export format from the Export drop down list 2 Click the Export button to the right of the drop down list 3 Next you will be prompted to save the exported file Note Up to the current release Microsoft Reporting Services e export capabilities to Excel are limited This limitation occurs where 1 the internal arrangement of the report consists of sub reports In this case the Excel document that is produced displays the following error message Sub reports within table matrix cells are ignored Export to PDF format is fully supported by Microsoft Reporting Services Version 3 1 Page 13 Eurekify 1 6 SageReports Changing Customer Logo All Sage reports display a company logo in the bottom left corner of the report By default the Sage Discovery and Audit logo functions as a placeholder as intended to be replaced by a client logo to customize the report to suit your company This must be performed locally on the machine on which Eurekify Sage Reports is installed Client Logo Sage Discovery amp Audit The logo is formatted as a bmp f
85. urces Reports Auditing and Compliance Reports Survey Reports Role Engineering Reports Role Maintenance Reports Privileges Certification Reports Version 3 1 Page 17 Eurekify SageReports 2 1 Configuration Reports 2 1 1 Configuration Properties Report General Shows general configuration counters and statistics similar to Sage Configuration Properties feature as well as pie charts of privileges distribution for users and resources That is percent of users with no resources users with dual resources etc Parameters Configuration Configuration Properties Report ter ton ConfigWithRoles UsarsDe 2 6 2006 12 00 00 AM User Privileges Distribution No Resources Recouroe Privsiegec Distribution Client Logo Page 1 of eure ify Sage Discovery amp Audit Sage Discovery amp Audit Figure 17 Configuration Properties Report Page 18 Version 3 1 Eurekify 2 1 2 Version 3 1 Configuration Entities Report SageReports General Lists all the configuration entities Users Roles Resources along with direct and total counters Parameters Configuration 5 26 10 2005 Configuration Entities Report EE Configuration ConfigWlthRoles3 Users Person ID User Name anization Organization Type Direct Total Direct Total Sage Discovery amp Audit 57644540 Alex Patrick Application Corporate 0 7 4 4 D
86. ver cannot decrypt the symmetric key This sometimes happens when changes are made to Microsoft Report Server 1 From Command Line run the command rskeymgmt d Click Y to delete data note It is OK to delete the data since only the connection string will be deleted and it is easily restored This will enable the server to create a new key and will solve the error Next go to http lt report server gt reports change lt report server gt to the name of your report server Go to the SageReports folder and then to the SDB In the text box next to Connection String type data source lt sgl server gt initial catalog lt sdb gt change lt sql server gt to the name of the SQL Server you use to store the Sage Reports database Change lt sdb gt to the name of the Sage Reports database usually sdb Under the textbox choose Connect using Windows NT Integrated Security Click Apply Page 16 Version 3 1 CHAPTER 2 Sage Reports Sage reports are arranged within subject or functional categories to provide easy access to specific reports This chapter provides a description of each report in each category providing a list of parameters that need to be entered for each report and a sample image of each report Descriptions of the reports are arranged according to the organization of report categories in the Sage Portal These include Configuration Reports Users and Reso
87. w Data Source Upload File f Report Builder EE Show Details Figure 1 Reporting Services Page 2 Version 3 1 Eurekify 1 2 SageReports Installing Sage Reports Eurekify Sage ERM Reports Server is installed by running the EurekifySageERM ReportsServer V30 msi file that you received as part of the Eurekify ERM Sage installation package To Install Sage Reports 1 Version 3 1 Locate and run the file to launch the installation wizard The splash screen appears automatically Click Next and the Welcome step appears Click Next to move to the license screen Read the license and accept the terms of the license agreement Click Next the Installation Settings step appears Accept or modify the values for the DB Name SQL Server Name Report Server URL and Web Folder Name iis Eurekify Sage Reports V3 0 E m eurekify Installation Settings att Tr BLA Please enter the following details DB Name sdb SQL Server Name Leave blank for default local Report Server URL http localhost reportserver Web Folder Name Recommended change default value only for multiple installations SageReports Cancel lt Back Figure 2 Installation Settings Default values are supplied for the Database Name Report Server URL and Web Folder name Change the DB Name and Report Server URL address according to your system requirements Eurekify recommends accepting the default Web Folder Name o
88. wner DEV MF Sage Role IT SageBank Indirect Roles None Dual Roles Roles count 1 ID Role Name Description Organization Owner 1143 BSAVELAN Sage Role im SageBank Client Logo eure Kify i Page 1 of 10 Sage Discovery 8 Audit Sage Discovery 8 Audit Figure 21 Configuration Users Full Report Page 22 Version 3 1 Eurekify 2 1 6 Configuration Resources Report Version 3 1 General Lists some all of a configuration s resources one per line Parameters Configuration By Field which resource field to chose users by From To Choose a range of values or leave empty for all Pattern Show only resources that match a pattern Configuration Resources Report Config ConfigWIthRoles3 By Field ResName123 From APPLDEV RACFTEST To UGSAVESYS Pattern NTSAVE WinNT Res Name 1 Res Name 2 Res Name 3 Owner Organization Dir Di Users Roles APPLDEV RACFTEST 1 4 appldev UNXMARKT MRKTLAN ng Sun 2 aritst NTSAVE WinNT BRANCHSAVE D BRLIMSYS RACFPROD RACF22 ROD Production RACF 4 0 DEVELOP RACFPROD RACF22 ROD Production RACF 2 0 DEVELOP RACFTEST RACF22 Test RACF 2 D Domain U NTSA WinNT BRANCHSAVE 1 D Domain NTSILV WinNT RANCHSILV 1 D Domain Users NTSTAM WinNT BRANCHSTAM 1 O e mail outlook WinNT 24 office2003 2003 WinNT 24 D PUBLIC RACFPROD ROD Production RACF 4 o PUBLIC RACFTEST STEST Test RA

User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents