Sumit12

for current date file count Name Count 5/31/2022 2

sorry but i am looking for file count monitoring for latest date i have prepared some thing but not able to print latest count with date get-childitem '\\NJIOILMSSQLU01\ilmsdata\VendorExport\NachaExport' | select @{n='Date';e={$_.LastWriteTime.ToShortDateString()}} | Group-Object Date | Format-Table Name, Count IF ($Count…

could you please below script for file monitor? and suggest if any changes required get-childitem 'PATH' | select @{n='Date';e={$_.LastWriteTime.ToShortDateString()}} | Group-Object Date | Format-Table Name, Count IF ($Count -gt 2) { $Message = 'there are wrong/duplicate files generated' Write-Host 'Statistic.Status: '2…

Hi Seashore, Thanks for sharing script after using this script i am getting same message/output in Issuer, Subject and expiration column earlier script i was using SELECT C.Name AS [Name] ,ISNULL(CS.Value,CTS.Value) AS [Website] ,S2.NumericData AS [Days until expire] ,S1.StringData AS [Issuer] ,S2.StringData AS…

Hi Seashore, Thanks for sharing script after using this script i am getting same message/output in Issuer, Subject and expiration column 

Hi Can we adjust the table a bit? * Issuer is required, but can we remove “Certificate Issuer is” from the data? * Subject would be more helpful if it was Subject Common Name * Can we also get a column for IP address? It helps our investigation.

thanks will try 

I tried you query and made some change # Set the Target URL $Url = $args[0] to # Set the Target URL $URL = "https://${IP}" not getting full information

Yes, I am able to get Issuer, Expiration and Subject information by above script. i have tried to add other required information but no result found. can you share any advance database query for report?

also i am unable to create custom report as required data filed is not showing under add columns can you share any advance database query for report?

can you add under script Valid From Thumbprint Subject Alternative Name 

Hi, we required to pull data for all server in report/excel sheet from template. 

above script not generating required data