azure / sql-action - File Age & Freshness

File age measurements show the distribution of file ages (days since the first commit) and the file freshness (days since the latest commit).

Summary

Number of files: 14
Daily file updates (only one update per file and date counted): 7192
First update: 2019-09-25
Latest update: 2024-12-09
Days between first and latest update: 1,903 (271 weeks, estimated 1,355 working days)
Active days (at least one file change): 79
Data:

Organized per file

File Change History Overall

File Age Distribution Overall

Days since first update

There are 14 files with 984 lines of code in files.

14 files that are 366+ days old (984 lines of code)
0 files that are 181-365 days old (0 lines of code)
0 files that are 91-180 days old (0 lines of code)
0 files that are 31-90 days old (0 lines of code)
0 files that are 1-30 days old (0 lines of code)

Legend:

366+

181-365

91-180

31-90

1-30

explore: grouped by folders | grouped by age

File Freshness Distribution Overall

Days since last update

There are 14 files with 984 lines of code in files.

7 files have been last changed 366+ days ago (179 lines of code)
7 files have been last changed 181-365 days ago (805 lines of code)
0 files have been last changed 91-180 days ago (0 lines of code)
0 files have been last changed 31-90 days ago (0 lines of code)
0 files have been last changed 1-30 days ago (0 lines of code)

Legend:

366+

181-365

91-180

31-90

1-30

explore: grouped by folders | grouped by freshness

File Change History per File Extension

ts, yaml, md, sql, json, js, gitignore, txt

File Age Distribution per Extension

Days since first update

366+

181-365

91-180

31-90

1-30

File Freshness Distribution per Extension

Days since last update

366+

181-365

91-180

31-90

1-30

File Change History per Logical Decomposition

primary

primary (file age distribution)

Days since first update

366+

181-365

91-180

31-90

1-30

primary (file freshness distribution)

Days since last update

366+

181-365

91-180

31-90

1-30

Oldest Files (Top 14)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
AzureSqlActionHelper.ts in src	335	18	2019-09-30	2024-06-28	7	4	asranja@microsoft.com	dzsquared@users.noreply.git...
AzureSqlResourceManager.ts in src	123	6	2019-09-30	2023-02-21	6	3	asranja@microsoft.com	dzsquared@users.noreply.git...
AzureSqlAction.ts in src	120	6	2019-09-30	2024-06-28	11	4	asranja@microsoft.com	dzsquared@users.noreply.git...
main.ts in src	96	3	2019-09-30	2024-07-01	13	5	asranja@microsoft.com	13544267+zijchen@users.nore...
FirewallManager.ts in src	26	3	2019-09-30	2022-11-03	7	3	asranja@microsoft.com	13544267+zijchen@users.nore...
SqlUtils.ts in src	105	4	2020-09-23	2024-07-01	5	3	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
Constants.ts in src	9	-	2020-09-23	2024-06-27	5	2	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
testsql.sql in __testdata__	2	-	2022-02-22	2022-09-28	3	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
cleanup.sql in __testdata__	1	-	2022-02-22	2022-02-22	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
DotnetUtils.ts in src	20	2	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Table1.sql in __testdata__/TestProject	5	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
View1.sql in __testdata__/TestProject	2	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
SqlConnectionConfig.ts in src	110	11	2022-09-28	2024-07-01	4	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Setup.ts in src	30	2	2022-09-28	2024-06-27	6	3	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...

Files Not Recently Changed (Top 14)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
cleanup.sql in __testdata__	1	-	2022-02-22	2022-02-22	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
View1.sql in __testdata__/TestProject	2	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Table1.sql in __testdata__/TestProject	5	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
DotnetUtils.ts in src	20	2	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
testsql.sql in __testdata__	2	-	2022-02-22	2022-09-28	3	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
FirewallManager.ts in src	26	3	2019-09-30	2022-11-03	7	3	asranja@microsoft.com	13544267+zijchen@users.nore...
AzureSqlResourceManager.ts in src	123	6	2019-09-30	2023-02-21	6	3	asranja@microsoft.com	dzsquared@users.noreply.git...
Constants.ts in src	9	-	2020-09-23	2024-06-27	5	2	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
Setup.ts in src	30	2	2022-09-28	2024-06-27	6	3	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
AzureSqlAction.ts in src	120	6	2019-09-30	2024-06-28	11	4	asranja@microsoft.com	dzsquared@users.noreply.git...
AzureSqlActionHelper.ts in src	335	18	2019-09-30	2024-06-28	7	4	asranja@microsoft.com	dzsquared@users.noreply.git...
main.ts in src	96	3	2019-09-30	2024-07-01	13	5	asranja@microsoft.com	13544267+zijchen@users.nore...
SqlUtils.ts in src	105	4	2020-09-23	2024-07-01	5	3	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
SqlConnectionConfig.ts in src	110	11	2022-09-28	2024-07-01	4	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...

Most Recently Created Files (Top 14)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
SqlConnectionConfig.ts in src	110	11	2022-09-28	2024-07-01	4	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Setup.ts in src	30	2	2022-09-28	2024-06-27	6	3	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
DotnetUtils.ts in src	20	2	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Table1.sql in __testdata__/TestProject	5	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
View1.sql in __testdata__/TestProject	2	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
testsql.sql in __testdata__	2	-	2022-02-22	2022-09-28	3	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
cleanup.sql in __testdata__	1	-	2022-02-22	2022-02-22	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
SqlUtils.ts in src	105	4	2020-09-23	2024-07-01	5	3	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
Constants.ts in src	9	-	2020-09-23	2024-06-27	5	2	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
AzureSqlActionHelper.ts in src	335	18	2019-09-30	2024-06-28	7	4	asranja@microsoft.com	dzsquared@users.noreply.git...
AzureSqlResourceManager.ts in src	123	6	2019-09-30	2023-02-21	6	3	asranja@microsoft.com	dzsquared@users.noreply.git...
AzureSqlAction.ts in src	120	6	2019-09-30	2024-06-28	11	4	asranja@microsoft.com	dzsquared@users.noreply.git...
main.ts in src	96	3	2019-09-30	2024-07-01	13	5	asranja@microsoft.com	13544267+zijchen@users.nore...
FirewallManager.ts in src	26	3	2019-09-30	2022-11-03	7	3	asranja@microsoft.com	13544267+zijchen@users.nore...

Most Recently Changed Files (Top 14)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
SqlConnectionConfig.ts in src	110	11	2022-09-28	2024-07-01	4	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
SqlUtils.ts in src	105	4	2020-09-23	2024-07-01	5	3	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
main.ts in src	96	3	2019-09-30	2024-07-01	13	5	asranja@microsoft.com	13544267+zijchen@users.nore...
AzureSqlActionHelper.ts in src	335	18	2019-09-30	2024-06-28	7	4	asranja@microsoft.com	dzsquared@users.noreply.git...
AzureSqlAction.ts in src	120	6	2019-09-30	2024-06-28	11	4	asranja@microsoft.com	dzsquared@users.noreply.git...
Setup.ts in src	30	2	2022-09-28	2024-06-27	6	3	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Constants.ts in src	9	-	2020-09-23	2024-06-27	5	2	58936966+aksm-ms@users.nore...	13544267+zijchen@users.nore...
AzureSqlResourceManager.ts in src	123	6	2019-09-30	2023-02-21	6	3	asranja@microsoft.com	dzsquared@users.noreply.git...
FirewallManager.ts in src	26	3	2019-09-30	2022-11-03	7	3	asranja@microsoft.com	13544267+zijchen@users.nore...
testsql.sql in __testdata__	2	-	2022-02-22	2022-09-28	3	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
DotnetUtils.ts in src	20	2	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
Table1.sql in __testdata__/TestProject	5	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
View1.sql in __testdata__/TestProject	2	-	2022-02-23	2022-02-23	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...
cleanup.sql in __testdata__	1	-	2022-02-22	2022-02-22	1	1	13544267+zijchen@users.nore...	13544267+zijchen@users.nore...