wei17hao10的博客

使用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

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

这里写目录标题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

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

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

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

这里写目录标题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

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

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

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

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

安装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

安装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

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