Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hi,
I'm using Power BI connected to the AD with few useful attributes like "Computer - createTimeStamp" and "Computer - Operating System".
We used SCCM to upgrade computer OS from Windows 7 to Windows 10 with keeping computer name.
In AD now I can see two computer attributes: select Computer - Object - Created and Modified. The problem appears when I use these attributes or with Power BI "createTimeStamp". Problem is that I can't see exact date when Windows 10 was install and we can't monitor Windows 10 installation progress because original "Created" attributed show the date when Windows 7 object was created.
Do you have any idea how to resolve this?
Regards!
Solved! Go to Solution.
Hi @tpoljak,
Based on the following blogs, attributes ModifyTimeStamp and WhenChanged keep the timestamp when an object is changed or modified, these two attributes are available to all the objects in Active Directory.
whenChanged and modifyTimeStamp - Active Directory
Use PowerShell to Find Changes to Active Directory
After you perform Windows upgrade and query AD attributes in Power BI Desktop, please search for ModifyTimeStamp and WhenChanged attributes and use them as the create date of Windows 10.
Thanks,
Lydia Zhang
Hi @tpoljak,
Based on the following blogs, attributes ModifyTimeStamp and WhenChanged keep the timestamp when an object is changed or modified, these two attributes are available to all the objects in Active Directory.
whenChanged and modifyTimeStamp - Active Directory
Use PowerShell to Find Changes to Active Directory
After you perform Windows upgrade and query AD attributes in Power BI Desktop, please search for ModifyTimeStamp and WhenChanged attributes and use them as the create date of Windows 10.
Thanks,
Lydia Zhang
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |