| 19 |
|
|
| 20 |
|
if __name__ == '__main__': |
| 21 |
|
|
| 22 |
< |
outputFileName = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\20220809-WindowsServer8_Matrix_Report.csv" |
| 22 |
> |
outputFileName = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\20220815-WindowsServer8_Matrix_Report.csv" |
| 23 |
|
|
| 24 |
|
## This should all be csvs with pre-selected fields that are verified didnt already contain pipes. Also a headder row. |
| 25 |
|
#win2kServersFile = r"C:\Users\eborges\Documents\Cases\Endo\20220715 - IG Projects\4 - Develop Identification Process to Inventory NCDS stored in Endo IT\_fromEndo\_csv\Win8Servers_filtered.csv" |
| 222 |
|
|
| 223 |
|
|
| 224 |
|
chngReqList = "" |
| 225 |
+ |
snBusinessOwnerList = set() |
| 226 |
|
if i in list(serviceNowToServersMatrix.keys()): |
| 227 |
|
nl=outputFile.write("|YES") |
| 228 |
|
for chngReqLine in serviceNowToServersMatrix[i]: |
| 236 |
|
chngReqList = chngReqList + "; " +chngReqNumbWDate |
| 237 |
|
else: |
| 238 |
|
chngReqList = chngReqNumbWDate |
| 239 |
+ |
if chngReqLine[3]: |
| 240 |
+ |
snBusinessOwnerList.add("%s [%s]"%(chngReqLine[3],chngReqLine[1])) |
| 241 |
+ |
|
| 242 |
|
else: |
| 243 |
|
nl=outputFile.write("|NO") |
| 244 |
|
if chngReqList: |
| 245 |
|
nl=outputFile.write("|" + chngReqList) |
| 246 |
|
else: |
| 247 |
|
nl=outputFile.write("|") |
| 248 |
+ |
if snBusinessOwnerList: |
| 249 |
+ |
nl=outputFile.write("|" + "; ".join(snBusinessOwnerList)) |
| 250 |
+ |
else: |
| 251 |
+ |
nl=outputFile.write("|") |
| 252 |
|
|
| 253 |
|
|
| 254 |
|
nl = outputFile.write("\n") |