wei17hao10-CSDN博客

原创 sql: 统计所有表记录数

使用sqlserver临时存储过程，统计所有表的记录数。中间涉及使用动态SQL，执行结果返回参数中。create procedure #whcountasbegin declare @cnt int declare @sql nvarchar(1000) declare @v_tablename nvarchar(100) declare i cursor for (select a.TableName from DialogTable a) open i fetch next

2021-09-18 18:14:47 1103

原创 sql: 无用表清理

SELECTs.Name AS SchemaName,t.Name AS TableName,p.rows AS RowCounts,DT.UID_DialogTable,CAST(ROUND((SUM(a.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Used_MB,CAST(ROUND((SUM(a.total_pages) - SUM(a.used_pages)) / 128.00, 2) AS NUMERIC(36, 2)) A

2021-09-06 15:27:31 135

原创 Setup of IT shop in demo environment

这里写目录标题Practice requestPractice environment preparationPractice stepsCreate a technical group named “mytest AD group” in ADAdd the IT Shop settings to the AD groupImplement approval (Department head approval)Add a new shelf to the existing IT ShopApply wor

2021-09-03 14:05:24 223

原创 How-to use Job Queue Info

How-to use Job Queue InfoOpen the ToolFind Frozen jobCheck the error logWhat we can do?Hello guys.This article is a general simple introduction about how to use Job Queue Info program. After watch this article, you may generally understand how to use thi

2021-09-02 18:38:49 230

原创 Export Person by Scripting

Export Person by ScriptingPractice requestPractice environment preparationPractice stepsBring up the SystemDebuggerCreate and edit the scriptSave the scriptHello guysBefore the content of this page, I would like to give my appreciation to @Oliver Paulzen

2021-09-02 18:32:05 115

原创 Setup of CSV Connector for data export

Hello guys,Before the actual content of this page, I would like to give my appreciation to @Oliver Paulzen who give us the training on last Wednesday and Thursday.At the end of Thursday training, Oliver shows us the demo about the CSV Connector project c

2021-09-02 17:10:11 267

原创 sql: daily check

这里写目录标题ScriptReadmeINTRODUCTIONEXECUTEADDManual templateSQL templateMODIFYDELETETESTTest stepsTemplateScript----This is a temporary procedure, used to print information in Messages box---------------In each session, it could only be executed one timecr

2021-09-02 14:54:51 135

原创 History DB Installation and Rotation

History DBThis article describes the installation and rotation of the History DBA new HDB should be created yearlyNaming: IAMHDB_image.pngimage.pngimage.pngCreate an entry for the source database.image.pngCreate an entry for the new HDB in the sou

2021-09-02 11:51:03 128

原创 Defect: 邮件模板显示内容不正确

项目场景：当客户申请某一项权限的时候，审核人会收到相应的邮件，里面会列出申请人的相关申请信息。问题描述：以下内容是终端用户给出的问题复现步骤。I can confirm my finding. Steps to reproduce.User A creates request in IAM. Reason for request: TESTrequest is declined by meUser A creates request in IAM again. Reason for req

2021-08-25 23:13:22 191

原创 One Identity Manager对接Active Directory

One Identity Manager对接Active Directory在安装好测试环境之后，这是第一个对接的对端系统。使用Synchronization Editor应用进行交互式配置对接，非常傻瓜。下面是对接截图。对接完成以后，可以在Manager的ADS模块中找到同步过来的数据信息。打开Synchronization Editor点击Next选择Active Directory Connector类型，点击Next点击Next点击Nextdomain是系统填写，不用自己填

2021-08-19 23:04:01 114

原创 One Identity JobQueue Monitoring

One Identity JobQueue MonitoringJob Queue各部分介绍顶部菜单栏登录信息窗口调取过滤按钮Jobqueue/Process HistoryJobqueuejob chain右键job右键Process HistoryProcess stepProcessDBQueueParametersSystem journal写本文的目的是总结进行jobqueue检查时常用的一些方法。Job Queue各部分介绍如下图是打开job queue之后的界面。下面将详细介绍界面中每一

2021-08-16 21:36:39 85

原创 Defect: Attestation无法选择alternative approver

Attestation无法选择alternative approver项目场景：问题描述：原因分析：解决方案：知识点回顾项目场景：正常情况下，基本上每一个attestation policy都有两种approver，一个是正常的approver，如果根据数据找不到approver，会有一个alternative approver来进行审批。问题描述：问题就出在当前没有approver，但是也不分配给alternative approver进行审批。下图就是这个流程，实际上，左边蓝色方框里是没有找

2021-08-12 23:00:08 92

原创安装one identity测试环境 - step 3 web组件安装

安装one identity测试环境 - step 3 web组件安装IIS系统属性安装安装oneIM web组件本文安装的软件是one identity的web组件，安装在oneIM2上。IIS系统属性安装打开server manager，选择右上角的Manage => Add Roles and Features，三个NextSelect server roles，勾选Web Server(IIS)，然后NextSelect features，默认，直接NextWeb Server

2021-08-12 00:13:47 95

原创安装one identity测试环境 - step 2 软件安装

安装one identity测试环境 - step 2 软件安装安装数据库安装One Identity软件安装数据库将SQL server 2019的镜像文件拷贝到虚拟机oneIM1中，解压，运行setup文件点击左边栏，Installation，右边点击 New SQL Server stand-alone installation or add features to an existing installation使用evaluation version，Next勾选同意license te

2021-08-11 21:55:56 193

原创安装one identity测试环境 - step 1 虚拟机准备

安装one identity测试环境 - step 1 虚拟机准备创建虚拟机设置Active Directory Group创建用户，配置权限关闭防火墙创建虚拟机安装好的Windows server 2019，复制出两台镜像，启动重置电脑配置，地址栏输入 C:\Windows\System32\sysprep，双击 sysprep.exe，勾选generalize，确认。系统会自动重启。第一台设置administrator密码为Admin1，第二台为Admin2两台都登录Administrator用

2021-08-10 22:11:22 341 2

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

wei17hao10的博客