iversond

  update psadm.psurldefn set url = 'LOCAL'
   where url_id = 'PPM_MONITOR';
  update psadm.psurldefn set url = 'LOCAL'
   where url_id = 'PPM_PPMI';

iversond

insert into PS_PTIASPUSERTGTS values ('VP1', 'FS92DEV');
insert into PS_PTIASPTARGETS values ('FS92DEV', ' ', '8.53.10', '8.53', '10', 'ENG');
insert into PS_PTIASPTARGETLNG values ('FS92DEV', 'ENG');

-- REM INSERTING into PS_PTIASPLOGTGT;
Insert into PS_PTIASPLOGTGT (DBNAME,PTIASPRPTNO,PTIASPPKGAPPLYDT) values ('FS92DEV',16245533,to_timestamp('29-MAR-14','DD-MON-RR HH.MI.SSXFF AM'));

iversond

---
title:          'psadmin.conf'
description:    'The first conference for PeopleSoft Administrators.'
long_description: >
  psadmin.conf is a 1 day conference specifically for PeopleSoft Administrators. 
  The conference features talks from expert admins on a variety of topics. 
  The goal of the conference is to expand your knowledge of PeopleSoft Administration 
  and make you a better admin.
location:       'University of Minnesota (West Bank Office Building)'
address:        '1300 2nd Street S, Minneapolis, MN, 55455'

iversond

component_postboot_setup_list:
  searching:
    run_control_id:           searching
    os_user:                  "%{hiera('domain_user')}"

    db_settings:
      db_name:                            "%{hiera('db_name')}"
      db_type:                            "%{hiera('db_platform')}"
      db_opr_id:                          "%{hiera('db_user')}"
      db_opr_pwd:                         "%{hiera('db_user_pwd')}"

iversond

$pia_domain_list = hiera('pia_domain_list')
if $pia_domain_list {
	$pia_domain_list.each |$domain_name, $pia_domain_info| {

		$baseWebPath = "${pia_domain_info['ps_cfg_home_dir']}\\webserv\\${domain_name}\\applications\\peoplesoft\\PORTAL.war"
		$root_signon_url = $pia_domain_info['root_signon_url']
		
		$pia_site_list = $pia_domain_info['site_list']
		$pia_site_list.each |$site_name, $site_info| {

iversond

psft_base_dir = "c:/psft"
env_type  = "fulltier"
db_name = "PSFTDB"
db_service_name = "PSFTDB"
db_host = "localhost"
admin_pwd = "Passw0rd#"
connect_pwd = "peop1e"
access_pwd  = "SYSADM"
opr_pwd = "PS"
# domain_conn_pwd = "P@ssw0rd#"

iversond

Start-Process -FilePath c:\ProgramData\chocolatey\bin\nssm.exe -ArgumentList 'install kibana-5.6.3 "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-command "& { c:\elastic\kibana\bin\startKibana.ps1 }"" ' -NoNewWindow -Wait

iversond

$env:kibana_home = "c:\elastic\kibana"

Set-Location $env:kibana_home
.\bin\kibana

iversond

$env:logstash_home = "c:\elastic\logstash"

cd $env:logstash_home
.\bin\logstash -f .\pipeline.conf -r -l .\logs\logstash.log --config.reload.automatic

iversond

Start-Process -FilePath c:\ProgramData\chocolatey\bin\nssm.exe -ArgumentList 'install logstash-5.6.3 "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-command "& { c:\elastic\logstash\bin\startLogstash.ps1 }"" ' -NoNewWindow -Wait