Hi
i have a curious problem. (btw. not my first Powershell input )
I am trying to Input some Active Directory Data into Splunk right now. Below a bit changed output of my Script:
...
See more...
Hi
i have a curious problem. (btw. not my first Powershell input )
I am trying to Input some Active Directory Data into Splunk right now. Below a bit changed output of my Script:
[
{
"SpecialUsers_S": false,
"SpecialUsers_X": false,
"SpecialUsers_U": false,
"SpecialUsers_A": false,
"SpecialUsers_TBM": false,
"SpecialUsers_T": false,
"HR_Canceled_Users": false,
"HR_Inactive_Users": false,
"HR_Temporary-Inactive_Users": false,
"FehlerStatus": "0",
"PasswordNeverExpires_State": "null",
"OU_State": "null",
"Account_State": "null",
"Manager_State": "null",
"Account_Expiration_Date": "null",
"EmployeeNumberError": "null",
"DescriptionError": "null",
"ManagersViaGroup": "null",
"Wrong_Name": "null",
"Wrong_EMail": "null",
"Manager_Description": "null",
"Multiple_SpecialGroups": "null",
"Multiple_HR_Groups": "null",
"SamAccountName": "SamAccount01",
"Enabled": true,
"EmployeeNumber": "11112",
"SN": "Surname01",
"Description": "0200000000",
"Department": "Department01",
"Company": "The Firm",
"emailaddress": "Email01@domain.com",
"DistinguishedName": "The Distinguished Name 01",
"hkDS-EntryDate": "09.09.1991 02:00:00",
"LastLogonDate": "18.07.2022 07:22:38",
"PasswordLastSet": "02.06.2022 09:22:36"
},
{
"SpecialUsers_S": false,
"SpecialUsers_X": false,
"SpecialUsers_U": false,
"SpecialUsers_A": false,
"SpecialUsers_TBM": false,
"SpecialUsers_T": false,
"HR_Canceled_Users": false,
"HR_Inactive_Users": false,
"HR_Temporary-Inactive_Users": false,
"FehlerStatus": "0",
"PasswordNeverExpires_State": "null",
"OU_State": "null",
"Account_State": "null",
"Manager_State": "null",
"Account_Expiration_Date": "null",
"EmployeeNumberError": "null",
"DescriptionError": "null",
"ManagersViaGroup": "null",
"Wrong_Name": "null",
"Wrong_EMail": "null",
"Manager_Description": "null",
"Multiple_SpecialGroups": "null",
"Multiple_HR_Groups": "null",
"SamAccountName": "SamAccount02",
"Enabled": true,
"EmployeeNumber": "11113",
"SN": "Surname02",
"Description": "000000000",
"Department": "Department02",
"Company": "The Firm",
"emailaddress": "email02@Domain.com",
"DistinguishedName": "The Distinguished Name 01",
"hkDS-EntryDate": "10.10.2002 02:00:00",
"LastLogonDate": "18.07.2022 08:07:31",
"PasswordLastSet": "26.05.2022 17:27:42"
}
]
Exported into File and testet with Validators all is fine.
But what i see in Splunk is:
"SpecialUsers_S": false,
"SpecialUsers_X": false,
"SpecialUsers_U": false,
"SpecialUsers_A": false,
"SpecialUsers_TBM": false,
"SpecialUsers_T": false,
"HR_Canceled_Users": false,
"HR_Inactive_Users": false,
"HR_Temporary-Inactive_Users": false,
"FehlerStatus": "0",
"PasswordNeverExpires_State": "null",
"OU_State": "null",
"Account_State": "null",
"Manager_State": "null",
"Account_Expiration_Date": "null",
"EmployeeNumberError": "null",
"DescriptionError": "null",
"ManagersViaGroup": "null",
"Wrong_Name": "null",
"Wrong_EMail": "null",
"Manager_Description": "null",
"Multiple_SpecialGroups": "null",
"Multiple_HR_Groups": "null",
"SamAccountName": "SamAccount01",
"Enabled": true,
"EmployeeNumber": "null",
"SN": "",
"Description": "null",
"Department": "null",
"Company": "",
"emailaddress": null,
"DistinguishedName": "The Distinguished Name",
"hkDS-EntryDate": "null",
"LastLogonDate": "null",
"PasswordLastSet": "null"
}
As u can see i am missing a lot of information, and i cant figure out why... Some like SamAccountName and DistinguishedName is working but other variables like Company, Department or Description are missing...
Skript is rather long but if needed i can post Parts of it how i do stuff
the inputs.conf for this is:
[powershell://Get_AD_Report]
script = . "$SplunkHome\etc\system\bin\Powershell\GetADReport.ps1"
schedule=15 * * * *
sourcetype=_json
index=hk_office365
Maybe someone as some kind of clue whats happening there for me?
Would really help am on this for much to long already and tried so many different ways now...