Question BigInt Conversion

[Polynominal]

I have a field that I am referencing in Windows AD - its datatype bigint, I am using the code below in a SSIS package, I am getting System.__ComObject as the output

if (entry.Properties["pwdlastset"].Value != null)
{
Output0Buffer.Pwdlastsetdate = entry.Properties["pwdlastset"].Value.ToString();
}

Does anybody know a way of getting the correct output?

Thanks

 

[Skydiver]

See StackOverflow:

C# get pwdLastSet from AD

I tried get "pwdLastSet" from AD but have problem with data convert. DirectoryEntry de = new DirectoryEntry(); DirectorySearcher ds = new DirectorySearcher(de); ds.Filter = "(&((&(objectCa...

stackoverflow.com

 

[Polynominal]

Thanks for this - I have tried it but get an invalidcastexception error

 

[Skydiver]

Post your code.

 

[NoUserHere]

In code tags...

 

[Polynominal]

        if (entry.Properties["pwdlastset"].Value != null)
                    {
                        long value = (long)entry.Properties["pwdLastSet"][0];
                        DateTime pwdLastSet = DateTime.FromFileTimeUtc(value);
                        Output0Buffer.Pwdlastsetdate = pwdLastSet.ToString();
                    }

 

[JohnH]

 

[JohnH]

I have tried it but get an invalidcastexception error

On which line?

 

[Skydiver]

This works for me:

var root = new DirectoryEntry(myLdapPath);
var searcher = new DirectorySearcher(root);
searcher.Filter = $"(SAMAccountName={myAccountName})";
var result = searcher.FindOne();
var cn = result.Properties["cn"][0];
Console.WriteLine($"{cn}");
var pwdLastSet = (long)result.Properties["pwdLastSet"][0];
Console.WriteLine($"{pwdLastSet}");
var lastSet = DateTime.FromFileTimeUtc(pwdLastSet);
Console.WriteLine($"{lastSet}");

Which produced the following output:

<redacted for privacy>
132515641876496955
12/04/2020 14:03:07

And yes, I did just change my password a few hours ago.

 

[Polynominal]

Hi Thanks for the above

How can I fit this into

if (entry.Properties["pwdlastset"].Value != null)
{
long value = (long)entry.Properties["pwdLastSet"][0];
DateTime pwdLastSet = DateTime.FromFileTimeUtc(value);
Output0Buffer.Pwdlastsetdate = pwdLastSet.ToString();
}

 

[NoUserHere]

Edit your post. I won't ask again.

 

[Skydiver]

My lines 7-10 are essentially the same as your lines 3-5. I just posted that code to show that it things work as advertised by the StackOverflow article I originally linked to.

My recommendation is to actually use a debugger instead of just running your code. When you get to that line that is throwing an exception, look at what kind of object is stored there.