Endpoint Privilege Manager (EPM) Articles
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Question What are the definitions of Event Types found in reports such as EPM Privilege Managements Events Full List and Application Control Event Full Lists? Answer 1. Skipped event is designed to deal with single applications that created thousands of events and bundle them into fewer events based on the same criteria of the original events. This feature was designed to reduce the the stress on the servers. 2. Elevation request is applications that do not have a policy but need to run as admin. 3. Launch requiring Admin is running an app with Admin privileges (use of Elevate or Trust policy) 4. Access Internet, Access Network Share, Access Intranet, Access Memory are detect attempts to access the internet, intranet, network shares and memory of other processes individually.
View full article
An addition to  "What email addresses and IP's are used for emails sent from EPM SaaS ?" KB article IP used for all EPM related emails -  167.89.29.177    SaaS password reset emails -  From US Data Center - [email protected] From EU/CA/IN/UK/AU/JP/SG Data Centers - [email protected]   New Events and reports are sent from [email protected] (XXX - 3 digits represent the SaaS server number)
View full article
Question Trusted network location policy will not work for child process.  Answer Trust action elevates ONLY IF the application REQUESTS ELEVATION. If the parent application did not require elevation than the child application will not be elevated. This is also true for Trusted network location policy application that creates a new file locally by the installation and the new file will not elevate as it will not inherit the elevation flag due to security reasons. There are two workarounds for the issue: 1. Create a Trusted Source by Publisher or Installation Package (instead of the Network Location Trusted Source)  OR 2. Create an additional Advanced policy for the relevant exe files as follows - Go to Advanced Policies->Create Application Policy->Elevate - In 'Application Type', select "Permit Application Installation" - In 'Installation', select "EXE Installation" - in 'Parameters' set only File Name to *.exe (in warning message box click on yes; this is security warning and later we will add a source to avoid the security risk) - 'Protect Installed Files' and 'Parent Process' settings can be left unchanged - In Source select "From Network Location:" and set the field value according to the network location in Trusted Source policy - Click on Finish and then complete creating the policy This Advanced policy, in addition to the existing Network Location Trusted Source, should solve the issue. Issue Hello, Running the following application from Trusted Network Location "http://vsphereclient.vmware.com/vsphereclient/1/2/3/0/3/8/6/9/VMware-ClientIntegrationPlugin-6.0.0-12303869.exe" doesn't work. After analysis in my testing enviroment (reprodice the behaviour is really easy) I found that this executable is a self-extracting 7zip package, which run the setup after unzipping it (all file, the package and zipped file are signed as “VMware, Inc.”. Basically the Trusted Network Location doesn't apply by default on child process. Quick solution is to create Trusted Signature for “VMware, Inc.” or a specific advanced policy. Customer report this "feature" as a limitation to use "Trusted Network Location", do you have any advice about the problem identifed or this is a "limitation" known? Thank you, Giulio Environment Component: Viewfinity Server Functional Area: Privilege Elevation Resolution Trust action elevates ONLY IF the application REQUESTS ELEVATION. If the parent application did not require elevation than the child application will not be elevated. This is also true for trusted application that create a new file locally by the installation and the new file will not elevate as it will not inherit the elevation flag due to security reasons.
View full article
Question I have applied the Remove Local Administrators default policy in my SaaS console. What can I do if a local admin was removed by mistake? Answer You can add a local admin to an endpoint using the CLI: On Mac: You can add user with name "username" to admin group: dscl . append /Groups/admin GroupMembership username On Windows: net group administrators USERNAME /ADD or net localgroup administrators USERNAME /ADD
View full article
Question Questions: 1) What are the regular maintenance hours for CyberArk EPM (SaaS)? 2) Will the maintenance happen during working hours? 3) Will an email notification be sent to us days ahead to inform us of the specific time of maintenance?   Answer If you have clicked on the "Subscribe to Updates" button from this website (https://status.epm.cyberark.com/) and enter the email address, the customer should get email notifications whenever CyberArk EPM creates, updates or resolves an incident, including time of maintenance. CyberArk EPM's status page shows the current health of our service, and is where you can get updates if there are any interruptions or outages. Issue Questions: 1) What are the regular maintenance hours for CyberArk EPM (SaaS)? 2) Will the maintenance happen during working hours? 3) Will an email notification be sent to us days ahead to inform us of the specific time of maintenance? Environment EPM SaaS Environment Resolution If you have clicked on the "Subscribe to Updates" button from this website (https://status.epm.cyberark.com/) and enter the email address, the customer should get email notifications whenever CyberArk EPM creates, updates or resolves an incident, including time of maintenance. CyberArk EPM's status page shows the current health of our service, and is where you can get updates if there are any interruptions or outages.
View full article
Homebrew or sometimes called just Brew, is a software distribution and installation utility for MacOS. An issue was raised where Homebrew requires the installation and running to be as a local admin only.  of course this is not a solution that maintains security level needed, hence the below script was generated to install Homebrew on the User context and not as admin/root Homebrew can be found here https://brew.sh/, but please follow the instructions below. Steps Open Root terminal session and paste the below scripting lines: # install Brew Script cd $HOME   echo "Home Address=$HOME ;"   gitVersionLog="$(git version)" echo "Git Version= $gitVersionLog ;" git clone https://github.com/Homebrew/brew.git echo "git Clone status=Success;"   echo 'export PATH=$HOME/brew/bin:$PATH' > .bash_profile echo "Create .bash_profile status=Success;"   echo 'export PATH=$HOME/brew/bin:$PATH' > .zshrc echo "Create .zshrc status=Success;"   chown -R $USER brew .bash_profile .zshrc echo "chown status=Success;"  
View full article
Q: How do I restore EPM databases from backup?   Steps A: 1. Open IIS Manager and stop your server. 2. login to Microsoft SQL Server Management Studio 3. Right click VFMNGDB5 and select Properties, in the next window on the left pane select Options, under State set Restrict Access to SINGLE_USER (This option only needs to be done for your VFMNGDB5 database) 4. Select your database backup files  - begin with restoring "VFSTAGEDB5", then "VFMNGDB5", then "VFNESTDB5", then "VFSTATDB5", then "VFEVENTSDB5" 5. Right click VFSTAGEDB5 -> Tasks -> Restore -> Database... 6. Select the backup sets to restore 7. Under Options > Select check-box to "Overwrite the existing database (WITH REPLACE)" 8. The restore of the database should complete successful (Repeat these steps for the other databases) 9. Perform only ONE of the following a. FOR  EPM v10.10+ = After restoring all of the databases, you need to authorize them in the system. - Right click on VFMNGDB5 > New Query - Write the command EXEC dbo.usp_VfScheduledJobReviveAfterRecovery - Click on !Execute in the toolbar (or hit F5) b. FOR EPM v5.5-10.9 = Manually !Execute the following query against all EPM Databases (VFMNGDB5, VFNESTDB5, VFSTAGEDB5, VFSTATDB5, VFEVENTSDB5) DECLARE @DbName nvarchar(max), @Principal sysname  SELECT @DbName = CONVERT(nvarchar(max), DB_NAME())  SELECT @Principal = name  FROM sys.server_principals  WHERE (sid = 0x01)  EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON')  EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];') Q: How do I restore database from backup? A: 1. Open IIS Manager and stop your server. 2. login to Microsoft SQL Server Management Studio 3. Right click VFMNGDB and select Properties, in the next window on the left pane select Options, under State set Restrict Access to SINGLE_USER (This option only needs to be done for your VFMNGDB5 database) 4. Right click VFMNGDB -> Tasks -> Restore -> Database... 5. Select your database backup files  - begin with restoring "VFSTAGEDB5", then "VFMNGDB5", then "VFNESTDB5", then "VFSTATDB5", then "VFEVENTSDB5") 6. Select the backup sets to restore 7. Under Options > Select check-box to "Overwrite the existing database (WITH REPLACE)" 8. The restore of the database should complete successful (Repeat these steps for the other databases) 9. Perform only ONE of the following 9a. FOR v10.10+ = After restoring all of the databases, you need to authorize them in the system. - Right click on VFMNGDB5 > New Query - Write the command "EXEC dbo.usp_VfScheduledJobReviveAfterRecovery" - Click on !Execute in the toolbar (or hit F5) 9b. FOR v5.5-10.9 = Manually !Execute the following query against all EPM Databases (VFMNGDB5, VFNESTDB5, VFSTAGEDB5, VFSTATDB5, VFEVENTSDB5) DECLARE @DbName nvarchar(max), @Principal sysname  SELECT @DbName = CONVERT(nvarchar(max), DB_NAME())  SELECT @Principal = name  FROM sys.server_principals  WHERE (sid = 0x01)  EXEC ('ALTER DATABASE [' + @DbName + '] SET TRUSTWORTHY ON')  EXEC ('ALTER AUTHORIZATION ON DATABASE::[' + @DbName + '] TO [' + @Principal + '];')
View full article
Question Why is the threat detection run status on My computers showing as "Running" but the policies for threat detection is deactivated? Answer The threat detection run status is showing as "Running" because the PASagent service is still running on the machine. There is a policy to collect credential accounts stored on end-user computers that uses the PASagent service, which is why it is showing as status running even with threat detection policies deactivated.  To stop the PASagent from running, you can disable the feature on the EPM console> Advanced > Agent Configuration > Data Collection> Collect Protected Accounts = Change to 'Off" (and then Save). You will see that the threat detection run status for your endpoints will change to "Not Running" on my computers tab. If customer is running Loosely Connected Devices (LCD), PASagent will also be running, they will need to disable LCD to stop the PASagent.
View full article
Question Q. There are many places to take an IP from, which ones does Endpoint Privilege Manager / Viewfinity use? Q2. How is Internet / Intranet defined? Answer A. EPM has the following knowledge about the IP addresses for each endpoint: 1. The IP addresses of all discoverable Network Interfaces on the Computer: they can be viewed in the Asset Inventory of a Computer, and in the corresponding Reports 2. The IP address, from where the VF Server received the last connection from this Computer, which is usually the external (WAN) address of a proxy or a NAT-device (router, modem, firewall, etc.): it can be viewed in the same Asset Inventory and Reports, and in addition in the “Info” dialog for the Computer 3. In case Network Access monitoring is turned on by VF Policies, the IP addresses connected from the Computer are collected too: they can be viewed in the Application Control Inbox, Policy Audit pane and the corresponding Reports A2. The definition of Intranet/Internet in EPM is as follows -  Intranet - all the private IPs and the network the console is in  Internet - everything else  How do we define "private IP's"? https://www.iplocation.net/public-vs-private-ip-address  Its a known range.  Currently, these settings are not configurable by the customer. If they would like to request a change in design of the product, this can be opened as a product enhancement request.  Q. There are many places to take an IP from, which ones does Endpoint Privilege Manager / Viewfinity use?   A. EPM / Viewfinity has the following knowledge about the IP addresses for each endpoint:   1. The IP addresses of all discoverable Network Interfaces on the Computer: they can be viewed in the Asset Inventory of a Computer, and in the corresponding Reports 2. The IP address, from where the VF Server received the last connection from this Computer, which is usually the external (WAN) address of a proxy or a NAT-device (router, modem, firewall, etc.): it can be viewed in the same Asset Inventory and Reports, and in addition in the “Info” dialog for the Computer 3. In case Network Access monitoring is turned on by VF Policies, the IP addresses connected from the Computer are collected too: they can be viewed in the Application Control Inbox, Policy Audit pane and the corresponding Reports   The definition of Intranet/Internet in EPM is as follows -  Intranet - all the private IPs and the network the console is in  Internet - everything else  How do we define "private IP's"? https://www.iplocation.net/public-vs-private-ip-address  Its a known range.  Currently, these settings are not configurable by the customer. If they would like to request a change in design of the product, this can be opened as a product enhancement request. 
View full article
How can I migrate EPM DB's to a different SQL instance? (for the purpose of SQL upgrade, SQL machine change, or otherwise) Steps Use the following steps- 1. Backup all DB's  - This can be done using the built in Backup Tool in the Administration page  Administration > Configuration > Backup Settings >  - Or manually for all DB"s that begin with VF  In 5.+ that means - VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5  2. Restore in new location/SQL instance and run revive script Please refer to How to restore EPM database from backup 3. Afterwards perform an Uninstall and Reinstall of the Manager from the IIS Machine.  During the reinstall, point the installation at the restored DB's in the "new" location. (Note it is critical that the IIS FQDN is the same as was used before)  When the "reinstall" or "upgrade install" happens with the installer, it will validate all user access and permissions, as well as update the connection points needed in the DB.  But if you are looking to validate afterwards, the connection strings can all be seen in the following 2 tables-  a. Expand VFMNGDB5 > find table called DBO.tblSetConfigs  b. Expand VFMNGDB5 > find table called vfdsp.tblManagerConnectionPoints  Note - We do not advise making any manual changes to these tables without consulting CyberArk.  Note2 - When you reinstall *it is crucial that the FQDN of the server stay the same.*  Note 3 - If upgrading SQL or changing the Reporting Services instance as well - make sure that the User Accounts for MS SQL Database and Reporting Services are given the "sysadmin" Server Role. This is only temporary and once the installation is completed, the user account will only need “db_owner” and “db_backupoperator” roles. The Reporting Services Account also requires local Administrator privileges. Q: How can I migrate EPM DB's to a different SQL instance? (for the purpose of SQL upgrade, SQL machine change, or otherwise)   A: Use the following steps- 1. Backup all DB's  - This can be done using the built in Backup Tool in the vfadmin/Administration page  Administration > Configuration > Backup Settings >    - Or manually for all DB"s that begin with VF  In 5.+ that means - VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5    2. Restore in new location/SQL instance and run revive script Please refer to *solution 3739*    3. Afterwards perform an Uninstall and Reinstall of the Manager from the IIS Machine.  During the reinstall, point the installation at the restored DB's in the "new" location. (Note it is critical that the IIS FQDN is the same as was used before)    When the "reinstall" or "upgrade install" happens with the installer, it will validate all user access and permissions, as well as update the connection points needed in the DB.    But if you are looking to validate afterwards, the connection strings can all be seen in the following 2 tables-  a. Expand VFMNGDB5 > find table called DBO.tblSetConfigs  b. Expand VFMNGDB5 > find table called vfdsp.tblManagerConnectionPoints    Note - We do not advise making any manual changes to these tables without consulting CyberArk.  Note2 - When you reinstall *it is crucial that the FQDN of the server stay the same.*  Note 3 - If upgrading SQL or changing the Reporting Services instance as well - make sure that the User Accounts for MS SQL Database and Reporting Services are given the "sysadmin" Server Role. This is only temporary and once the installation is completed, the user account will only need “db_owner” and “db_backupoperator” roles. The Reporting Services Account also requires local Administrator privileges.
View full article
Question This article will aim to cover Q1. What external RestAPI's are available? / Where is the documentation for how to implement? Q2. Basic Troubleshooting steps? Answer A1. What external RestAPI's are available?  Where is the documentation for how to implement? (Valid as of EPM v10.10) - EPM Authentication = EPM Authentication API Requirements - WIndows AD Authentication (on-premise only) = Windows Authentication API Requirements - Get EPM Version = Get EPM Version API Requirements - Get Set List = Get Sets List API Requirements - Get Aggregated Events = Get Aggregated Events API Requirements - Get Raw Events = Get Raw Events API Requirements - Get Raw Event Details = Get Raw Event Details API Requirements A2. Basic Troubleshooting steps? The tool used by EPM Support for testing/troubleshooting EPM RestAPI is Postman (https://www.getpostman.com/apps) This will allow you to create the request which is failing for you in your environment and export it to us. If same request works in postman, it indicates the issue is in the surrounding code and out of the scope of EPM Support. Instructions for using Postman to export a .JSON file and sending it to us.  1. Kindly install Postman and assemble your request in it. Test if it works. 2. If still broken, you can export the collection/environment by performing the following:  3. Clicking Postman's 'File' top menu entry at the top-left side of the screen.  4. Choose 'Settings' from the drop-down menu.  5. Click 'Data' in the upper-navigation menu.  6. Click 'Download' - This will download all collections, environments, global variables and header presets to a single JSON file.  7. Send Support the JSON file and to import and review.  8. (for On-premise customer's only) - please also export the EPM Server Trace taken after the failed API requests were tested. (Instructions for EPM - Exporting Server Trace / ServerData) Additional Reference = EPM - RestAPI Limitations
View full article
Issue: An upgrade will fail with errors like these in the installation log: Action: DBUpgradeInst. 09:57:48 SqlInstTask: Changed database context to 'VFMNGDB5'.  Action: DBUpgradeInst. 09:57:48 SqlInstTask: ERROR STATEMENT: ALTER DATABASE [VFMNGDB5] SET SINGLE_USER WITH ROLLBACK IMMEDIATE  USE [VFMNGDB5]  ERROR: The operation cannot be performed on database "VFMNGDB5" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.  ALTER DATABASE statement failed.  Action: DBUpgradeInst. 09:57:48 SqlInstTask: : ERROR (4392,5): ERROR: The operation cannot be performed on database "VFMNGDB5" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.  ALTER DATABASE statement failed.  Action 9:58:11: CustomAction. Steps Resolution: The resolution is:  - Disable the activated "Mirroring" or "Always On" features.  - Run the upgrade  - Turn back on the features.  The EPM upgrade will not work with "Mirroring" or "Always On" features turned on. SYMPTOM: During upgrade process a dialog message: "The instruction at 0x8e2c5d90 referenced memory at 0x8e2c5d90. The memory could not be written" Then, after clicking OK the upgrade fails   In the Server trace the following error message appears: ERROR: The operation cannot be performed on database "VFMNGDB5" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. ALTER DATABASE statement failed.   PROBLEM: An activated "Mirroring" or "Always On" running on the EPM DB's. The upgrade process doesn't support DR\Redundancy features turning ON.     SOLUTION: - Disable the activated "Mirroring" or "Always On" features. - Run the upgrade - Turn back on the features.
View full article
How to collect the EPM agent installation logs? Steps 1.  At the final page of the EPM agent installation there is a checkbox to show the installation logs, check the box and click OK and save the installation logs on the desktop.  2. Logs can be located at C:\Windows\Temp *note that EPM upgrade log can be found here as "VFUpgrade.log"
View full article
Question Once you disable self-defense using the vf_agent.exe -UseToken command, how do you re-enable self-defense?    Answer Restart agent and the self-defense will be enabled again. Issue Once you disable self-defense using the vf_agent.exe -UseToken command, how do you re-enable self-defense? 
View full article
Question Testing an ad-hoc policy on a client , but not able to run any elevated products. Answer 1. The ah-hoc user elevation policy was only release on EPM 11.0 so it will only work with the new EPM agent 11.0. If the agent version is lower than version 11, upgrade the agent to version 11 and the policy will work. 2. On the policy under Permissions (Local Groups),  make sure to select roles e.g "Administrators" so that the user will have the admin role for the duration of the ad-hoc policy Issue Testing an ad-hoc policy on a client , but not able to run any elevated products. Environment Component: SaaS Functional Area: Privilege Elevation Resolution Update agent to EPMv11.0 and it is working.
View full article
Question Customer is on LCD (Loosely Connected Device) license only EPM and do not see inventory information on EPM console> My Computers> click on endpoint hostname to open computer. The inventory page shows a blank screen. Answer This is as designed, LCD license only EPM will not be able to view inventory information of endpoints. If customer need to see the Local administrator information, they can view them from reports, Users in Local Administrators Group.  EPM console> Report> Privilege Management Reports > "Users in Local Administrators Group" (Just click on "Users in Local Administrators Group")
View full article
When customer tries to login to EPM and see ComponentArt Dialog as below: This usually means the EPM server (IIS) lost connection to the SQL database or that the SQL database server is non-responsive. Steps A simple restart of the IIS server should re-establish the connection or to do a proper power cycle of the EPM environment. 1. shutdown IIS server, 2. shutdown DataBase server, 3. start DataBase server, 4. start IIS server If the above does not work then refer to Article EPM - ComponentArt Dialog :: Unlicensed version message on login screen here where the EPM service account was changed.
View full article
Question I have changed the server timezone on EPM console, but the administration report under EPM console> Administration> Reports are all showing the server time in GMT+0. Answer All administration Reports are displayed as GMT+0 only. This timezone cannot be changed and is fixed.
View full article
Question Note: Many DBA’s review our database setting and have questions on why and what these settings are used for.  Here are the most common issues Q1: Does Viewfinity user need to be assigned the sysadmin role? Q2: Currently Viewfinity needs to have Trustworthy setting enabled. Why? Q3: Why do we need xp_cmdshell enabled in SQL? Q4: What Permission the db_backupoperator have and what it needed for?  Answer A1: SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require DBOwner only. Some examples of the actions performed by our installation that require the "SA" Role are as follows:   Add TRUSTWORTHY property (for unsafe/external assemblies - see below) Enable CLR (to allows .NET code to be executed in scope of SQL DB) Add unsafe assemblies (see below) Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup) Various actions that overall require combinations of various different Roles, that is achieved in the simplest way by using the "SA" Role, e.g.: Temp DB creation during upgrade / DB creation during installation (requires "dbcreator" Role) Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,etc. (requires "diskadmin" Role) A2: The TRUSTWORTHY property is required for UNSAFE assemblies (see below). The assemblies should have UNSAFE_ACCESS permission due to the following reasons: The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have UNSAFE_ACCESS permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable. The assemblies that do not have UNSAFE_ACCESS permission has no access to some built-in .NET framework functionality A3: The value xp_cmdshell is set to 'TRUE', to enable free-disk space check, by the upgrade backup process. It is needed only for installation/upgrade, and it can be removed later. A4: db_backupoperator Permission is to perform backup of EPM DB from within the EPM Admin Console.  It is needed only for installation/upgrade, and it can be removed later. Issue Note: Many DBA’s review our database setting and have questions on why and what these settings are used for.  Here are the most common issues Q: Does Viewfinity user need to be assigned the sysadmin role? A: SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require DBOwner only. Some examples of the actions performed by our installation that require the "SA" Role are as follows:   Add TRUSTWORTHY property (for unsafe/external assemblies - see below) Enable CLR (to allows .NET code to be executed in scope of SQL DB) Add unsafe assemblies (see below) Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup) Various actions that overall require combinations of various different Roles, that is achieved in the simplest way by using the "SA" Role, e.g.: Temp DB creation during upgrade / DB creation during installation (requires "dbcreator" Role) Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,etc. (requires "diskadmin" Role) Q: Currently Viewfinity needs to have Trustworthy setting enabled. Why? A: The TRUSTWORTHY property is required for UNSAFE assemblies (see below). The assemblies should have UNSAFE_ACCESS permission due to the following reasons:   The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have UNSAFE_ACCESS permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable. The assemblies that do not have UNSAFE_ACCESS permission has no access to some built-in .NET framework functionality Q: Why do we need xp_cmdshell enabled in SQL? A: The value xp_cmdshell is set to 'TRUE', to enable free-disk space check, by the upgrade backup process. Q: What Permission the db_backupoperator have and what it needed for?  A: db_backupoperator Permission is to perform backup of EPM DB from within the EPM Admin Console. Steps Note: Many DBA’s review our database setting and have questions on why and what these settings are used for.  Here are the most common issues Q: Does Viewfinity user need to be assigned the sysadmin role? A: SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require DBOwner only. Some examples of the actions performed by our installation that require the "SA" Role are as follows:   Add TRUSTWORTHY property (for unsafe/external assemblies - see below) Enable CLR (to allows .NET code to be executed in scope of SQL DB) Add unsafe assemblies (see below) Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup) Various actions that overall require combinations of various different Roles, that is achieved in the simplest way by using the "SA" Role, e.g.: Temp DB creation during upgrade / DB creation during installation (requires "dbcreator" Role) Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,etc. (requires "diskadmin" Role) Q: Currently Viewfinity needs to have Trustworthy setting enabled. Why? A: The TRUSTWORTHY property is required for UNSAFE assemblies (see below). The assemblies should have UNSAFE_ACCESS permission due to the following reasons:   The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have UNSAFE_ACCESS permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable. The assemblies that do not have UNSAFE_ACCESS permission has no access to some built-in .NET framework functionality Q: Why do we need xp_cmdshell enabled in SQL? A: The value xp_cmdshell is set to 'TRUE', to enable free-disk space check, by the upgrade backup process. Q: What Permission the db_backupoperator have and what it needed for?  A: db_backupoperator Permission is to perform backup of EPM DB from within the EPM Admin Console. Note: Many DBA’s review our database setting and have questions on why and what these settings are used for.  Here are the most common issues Q: Does Viewfinity user need to be assigned the sysadmin role? A: SA is required during upgrade only, it's possible to remove it afterwards. For the regular work we require DBOwner only. Some examples of the actions performed by our installation that require the "SA" Role are as follows:   Add TRUSTWORTHY property (for unsafe/external assemblies - see below) Enable CLR (to allows .NET code to be executed in scope of SQL DB) Add unsafe assemblies (see below) Detect backup Folder in Windows Registry (to configure the Viewfinity DB backup) Various actions that overall require combinations of various different Roles, that is achieved in the simplest way by using the "SA" Role, e.g.: Temp DB creation during upgrade / DB creation during installation (requires "dbcreator" Role) Backup of the Viewfinity database: to check/create backup directory on disk; to delete old backup files,etc. (requires "diskadmin" Role) Q: Currently Viewfinity needs to have Trustworthy setting enabled. Why? A: The TRUSTWORTHY property is required for UNSAFE assemblies (see below). The assemblies should have UNSAFE_ACCESS permission due to the following reasons:   The assemblies are actively used from within the DB Stored Procedures and Functions. If an assembly does not have UNSAFE_ACCESS permission, it is unloaded after each execution of a call that causes dramatic performance degradation (up to 1000%), that sometimes makes the procedures just unusable. The assemblies that do not have UNSAFE_ACCESS permission has no access to some built-in .NET framework functionality Q: Why do we need xp_cmdshell enabled in SQL? A: The value xp_cmdshell is set to 'TRUE', to enable free-disk space check, by the upgrade backup process.   Q: What Permission the db_backupoperator have and what it needed for?  A: db_backupoperator Permission is to perform backup of EPM DB from within the EPM Admin Console.      
View full article
In the past, customers/Support have sometimes upgraded an endpoint Agent to a version higher than the version of the associated EPM Server to test if if the new Agent version resolved an issue on the endpoint. Therefore some customers and Support know this to have been a valid test method in some cases. Steps EPM Agent versions 11.5 and higher will NOT communicate with an EPM Server version 11.4 or older. Do not upgrade an endpoint with EPM Agent version 11.5 or higher unless the EPM Server is also version 11.5 or higher.
View full article
Question How do I submit a request for a new EPM license? Answer Contact your Account Executive. Your Account Executive will then reach out to our Licensing team to get your license approved and generated. Issue A: Contact your Account Executive and provide them your desired license details along with your Set ID. This is an approximately 30 character mixture of numbers and letters that is used to bind the license key to the Server instance. It can be found by clicking the license request button on the VF/EPM console > Advanced > My Account > 'Click here to acquire a new license'. Your Account Executive will then reach out to our Licensing team to get your license approved and generated.   NOTE - If you are unaware or cannot reach your Account Executive please submit a case to Support with the above details. Q: How do I submit a request for a new/additional EPM license?  
View full article
Issue: You may wish to copy the Loosely Connected Device (LCD) key between sets. Attached to this article (Sync_LCD_Key.zip) are a script that will do that for you, and instructions on how to use the script. Steps The attached script should copy the security key value from one set to another. 1. Make sure the DB connection points To VFEVENTSDB5 When running 2. Assumption: the 2 sets are in the same DB 3. Input parameters: Source Set Source Policy name Target Set Target policy name From the beginning of the script: --Source Policy Name & SetId  @SourcePolicyName nvarchar(512) = N'LCD1',  @SourceSetId uniqueidentifier = '365C75BC-10DF-4F5A-BE42-EE6CBBCCE4D0',  --Target Policy Name & SetId  @TargetPolicyName nvarchar(512) = N'testpolicy',  @TargetSetId uniqueidentifier = 'D9D7BC47-7601-4464-B2A4-F037FFBC325F'   The security key value should be copied from the policy in the source set to the policy in the target set.
View full article
Question Q: Where can I find the EPM Server installation or upgrade logs? Answer A: You can gather the VFMNG log from %TEMP%\VFMNG.log located on the machine where EPM Server is installed (you will need to log in as the user that performed the installation).  
View full article
Question When installing the EPM Agent using SCCM, why does it install correctly when used in Package format as opposed to installing incorrectly when used in Application format? Answer First - Please ensure that SCCM is configured as a Trusted Software Distributor with a configured policy for Applications newly installed by this Software Distributor.  Additionally, please note that EPM will only correctly assign this policy if software are pushed out as packages (and not applications) with SCCM.  In SCCM there are two basic ways to deploy applications 1) applications and 2) packages. Applications that deploy via packages are launched by SCCM processes and correctly registered by EPM with SCCM as the source and appropriate policies will work. On the other hand if software is deployed as an application, then the install is triggered by WmiPrvSE.exe using service DcomLaunch which are both part of Windows OS and not SCCM, with the result being the EPM does see them as sourced by SCCM, and the appropriate policies will not be applied. For more information - See 2 Microsoft resources Packages - https://technet.microsoft.com/en-us/library/gg682178.aspx, Applications - https://docs.microsoft.com/en-us/sccm/apps/deploy-use/deploy-applications.
View full article
  • 234 Posts
  • 18 Subscriptions
Top Liked Posts in LIVEcommunity Article
Top Liked Authors