We are running into an issue that supplier are trying to charge us for the software we already paid previous for the new financial year.

Luckily we are using groups to manage SCCM package installation and through query those group member join date we can roughly get the installation date, hence only pay for what we need to pay other than pay what they want.

We are talking about $200,000 AUD here.


any way, here is the script in powershell:

Get-ADGroup -filter {Name -like "*<GroupName>*" } | Get-ADReplicationAttributeMetadata -showalllinkedvalues -server <DCName>|  Select-Object FirstOriginatingCreate
Time, Object, AttributeValue      | Sort-Object FirstOriginatingCreateTime -Descending | export-csv .\groupMemberJoiningDate.csv


I take no credit from this and here is the reference I used:



About Lei

I am an IT specialist with over 10 year experience - years on Automation, on-Premise or Azure.

I am happy to develop however never want be a full time developer. Only do what I have to do. If it has to be PowerShell,HTML, PHP, CSS, C#, VBS or JS, front end or backend, so be it, doesn't matter!

Spent years with Windows, SCCM, SharePoint, SQL and Exchange servers. For last several years, I have been actively working under On Premise > Azure environment.


Current Certificates:
    Microsoft® Certified-
  • -Enterprise Administrator
  • -Database Administrator
  • -SharePoint Administrator
  • -Administering and Deploying SCCM 2012
Red Hat Certified Technician
ITIL V3 Foundation - Practitioner

Working on Azure Certificates now and hopefully they can stop upgrading their questions one day! GIVE ME A BREAK!

Contact Lei

Name *
Email *
Comments *

Traffic since 10/08/2016

This week264
This month2413

Visitor Info

  • IP:
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online