This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Contar Lineas en Archivos Individuales | |
(Get-Content -Path "D:\SSIS\ImportRIPS\Archive\AC.txt").Count | |
# Contar Lineas en Multiples Archivos | |
(Get-ChildItem -Path "D:\SSIS\ImportRIPS\AC\" -Filter *.txt -Recurse | Get-Content | Measure-Object -Line).Lines |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Permitir Ejecución de Scripts en PowerShell | |
Set-ExecutionPolicy RemoteSigned | |
# Unir Todos los Archivos RIPS en un solo archivo de cada tipo | |
Get-Content -Path "D:\SSIS\ImportRIPS\AC\*.txt" | Set-Content -Path "D:\SSIS\ImportRIPS\Archive\AC.txt" | |
Get-Content -Path "D:\SSIS\ImportRIPS\AF\*.txt" | Set-Content -Path "D:\SSIS\ImportRIPS\Archive\AF.txt" | |
Get-Content -Path "D:\SSIS\ImportRIPS\AH\*.txt" | Set-Content -Path "D:\SSIS\ImportRIPS\Archive\AH.txt" | |
Get-Content -Path "D:\SSIS\ImportRIPS\AM\*.txt" | Set-Content -Path "D:\SSIS\ImportRIPS\Archive\AM.txt" | |
Get-Content -Path "D:\SSIS\ImportRIPS\AN\*.txt" | Set-Content -Path "D:\SSIS\ImportRIPS\Archive\AN.txt" | |
Get-Content -Path "D:\SSIS\ImportRIPS\AP\*.txt" | Set-Content -Path "D:\SSIS\ImportRIPS\Archive\AP.txt" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
exports = async function(payload, response){ | |
const { q } = payload.query; | |
let searchTerm = ""; | |
let query = {}; | |
let findResult; | |
if (typeof q !== 'undefined' && q !== "") { | |
searchTerm = q; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
exports = async function(payload, response){ | |
const { q } = payload.query; | |
const mongodb = context.services.get("mongodb-atlas"); | |
const serviciosCollection = mongodb.db("referencias").collection("Servicios"); | |
var findResult; | |
try { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Inserción Datos en SQL Lite | |
INSERT INTO Ciudades VALUES | |
(76001, "Cali"), | |
(5001, "Medellin"), | |
(10001, "Bogota"), | |
(8001, "Barranquillas"), | |
(13001, "Cartagena") | |
; | |
INSERT INTO Clientes VALUES |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Código para Creación de Tablas en SQL Lite | |
CREATE TABLE "Ciudades" ( | |
"IdCiudad" INTEGER NOT NULL, | |
"Ciudad" TEXT, | |
PRIMARY KEY("IdCiudad") | |
);; | |
CREATE TABLE "Clientes" ( | |
"NIT_Cliente" INTEGER NOT NULL UNIQUE, | |
"Nombre" TEXT, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Import-Csv .\Users.csv | foreach-object { | |
New-ADUser ` | |
-SamAccountName $_.SamAccountName ` | |
-UserPrincipalName $_.userPrincipalName ` | |
-Name $_.name ` | |
-DisplayName $_.name ` | |
-GivenName $_.GivenName ` | |
-Surname $_.SurName ` | |
-Company $_.Company ` | |
-Path $_.OU ` |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
############################################################ | |
### ### | |
### Crear Unidades Organizativas ### | |
### ### | |
############################################################ | |
#Crear Unidad Organizativa en la raiz del Dominio | |
New-ADOrganizationalUnit -Name Hospital | |
#Crear Unidad Organizativa Remotos dentro de la OU Hospital |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
############################################################ | |
### ### | |
### Instalar Rol de Active Directory Domain Services ### | |
### ### | |
############################################################ | |
Install-WindowsFeature AD-Domain-Services -IncludeAllSubFeature -IncludeManagementTools | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
######################################################## | |
### ### | |
### Prerrequisitos Instalacion Directorio Activo ### | |
### ### | |
######################################################## | |
### __ Identificar Tarjeta de Red Principal ___ ### | |
### _______________________________________________ ### | |
NewerOlder