search

EvotecIT / PSWinReporting

This PowerShell Module has multiple functionalities, but one of the signature features of this module is the ability to parse Security logs on Domain Controllers providing easy to use access to AD Events.
MIT License
701 stars 69 forks source link

MS SQL Output: Error occured (Send-SqlInsert) #74

Closed Adecosta1 closed 1 year ago

Adecosta1 commented 1 year ago

Do i need to install a SQL express? got the following errors?


am. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
[2022-08-05 16:57:43] [i] MS SQL Output: IF NOT EXISTS ( SELECT 1 FROM  dbo.[Events]  WHERE [DomainController] = 'AD1-adc01.domain.com' AND [EventRecordID] = '144945
6008' ) BEGIN INSERT INTO  dbo.[Events] ( [DomainController],[Action],[ComputerLockoutOn],[UserAffected],[ReportedBy],[EventWhen],[EventID],[EventRecordID],[
GatheredFrom],[GatheredLogName],[EventAdded],[EventAddedWho] ) VALUES ( 'AD1-adc01.domain.com','A user account was locked out.','LPTH1YHWZ2
','prakam001','PROD\AD1-ADC01$','2022-08-05 16:22:03','4740','1449456008','AD1-adc01.domain.com','Security','2022-08-05 16:57:42','
001admin' ) END
[2022-08-05 16:57:43] [i] MS SQL Output: Error occured (Send-SqlInsert): The term 'Invoke-DbaQuery' is not recognized as the name of a cmdlet, function, script file, or operable progr
am. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
[2022-08-05 16:57:43] [i] MS SQL Output: IF NOT EXISTS ( SELECT 1 FROM  dbo.[Events]  WHERE [DomainController] = 'wbl-adc02.domain.com' AND [EventRecordID] = '604598
901' ) BEGIN INSERT INTO  dbo.[Events] ( [DomainController],[Action],[ComputerLockoutOn],[UserAffected],[ReportedBy],[EventWhen],[EventID],[EventRecordID],[G
atheredFrom],[GatheredLogName],[EventAdded],[EventAddedWho] ) VALUES ( 'wbl-adc02.domain.com','A user account was locked out.','LPT3TX5L72'
,'BoehmTi','PROD\WBL-ADC02$','2022-08-05 16:31:00','4740','604598901','wbl-adc02.domain.com','Security','2022-08-05 16:57:42','a
dmin' ) END
[2022-08-05 16:57:43] [i] MS SQL Output: Error occured (Send-SqlInsert): The term 'Invoke-DbaQuery' is not recognized as the name of a cmdlet, function, script file, or operable progr
am. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
[2022-08-05 16:57:43] [i] MS SQL Output: IF NOT EXISTS ( SELECT 1 FROM  dbo.[Events]  WHERE [DomainController] = 'AD1-adc01.domain.com' AND [EventRecordID] = '144958
7598' ) BEGIN INSERT INTO  dbo.[Events] ( [DomainController],[Action],[ComputerLockoutOn],[UserAffected],[ReportedBy],[EventWhen],[EventID],[EventRecordID],[
GatheredFrom],[GatheredLogName],[EventAdded],[EventAddedWho] ) VALUES ( 'AD1-adc01.domain.com','A user account was locked out.','LPT3TX5L72
','BoehmTi','PROD\AD1-ADC01$','2022-08-05 16:33:01','4740','1449587598','AD1-adc01.domain.com','Security','2022-08-05 16:57:42','00
1admin' ) END`
Adecosta1 commented 1 year ago

https://evotec.xyz/hub/scripts/pswinreporting-powershell-module/

PrzemyslawKlys commented 1 year ago

You need to have DbaTools (PowerShell module) for SQL functionality. SQL Express or any SQL is required but for the database to exist.